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.
=SUMPRODUCT((B$1=Raw!$A$2:$A$9)*(Summary!$A2=Raw!$B$1:$M$1)*Raw!$B$2:$M$9)
You can use this SUMPRODUCT formula. See your attached file.