Hello,
I have been trying to sum monetary data by matching text in a heading as well as a specific term in column M and based on the matches obtain the summed monetary amounts in the particular assigned rows and column(s). I've tried these two formulas which I found online but they don't seem to work and give me the dreaded #VALUE. I've tried these formulas:
=SUMPRODUCT((D5:K5=D5)*(M6:M22=G23)*(D6:K22))
&
=SUMIFS($D$6:$D$22,$M$6:$M$22,G24,$D$5:$K$5,D5)+SUMIFS($H$6:$H$22,$M$6:$M$22,G24,$D$5:$K$5,H5)+SUMIFS($I$6:$I$22,$M$6:$M$22,G24,$D$5:$K$5,I5)
Would really appreciate your help & expertise! Thank you!
Bookmarks