Forum Discussion
sumif horiztonally and vertically
how can i update my formula in the summary tab such that when i drag my formula down it finds the month and pulls in the correct column from the raw data tab.
ctone00 One option with SUMIF is to use XLOOKUP (or INDEX/MATCH) in the [sum_range] argument:
=SUMIF(Raw!$A:$A,B$1,XLOOKUP($A2,Raw!$B$1:$M$1,Raw!$B:$M))
Then drag down and across as needed. Personally, I would not use entire column references here, but such is your example...