SUM with arrayformula with dropdown condition

Question

I have month name in cell B1 (Sheet Name- MS-HSD) in drop-down and have month wise sales data in column T4 to AE2082. I want sum in AF4 to AF2082 with condition in cell B1 ex. If I select B1=August then sum of April to August should display in AF4 to AF2082, similarly If I select B1=Jan then sum of April to Jan should display in AF4 to AF2082. Currently I am using SUM function with offset and vlookup. In this case same function was applied for all 2082 row.

Answer 1

In cell AF3, enter this formula

=SUM($T3:XLOOKUP($B$1,$T$2:$AE$2,$T3:$AE3))

hope this helps.

Answer 2

Hi,

Share data in a format that can be pasted in an MS Excel file. Show the expected result.

https://indianoilworkplace-my.sharepoint.com/:x:/g/personal/shailendra_indianoil_in/EXiH3-Jj2BJCh8IDNoU0uWEBODMeD5iRdNYnfZdYuqio-A?e=EKuJ9Z

Answer 3

Hi,

Share data in a format that can be pasted in an MS Excel file. Show the expected result.