Sumif

[Hoosier03]

I am using Excel 2007. Can someone tell me why the formula below does not work?


=IF(G$4="a",SUMIF('AOP Query'!$G$22:$G$440, $C30,'AOP Query'!$I$22:$L$440),0)


It is only adding one of the columns in the "AOP Query'!$I$22:$L$440" portion. I know this because I made a pivot table and the result that I am getting is exactly equal to one weeks worth of data and not 4.

Thanks

 

[Jonmo1]

Because SUMIF compares arrays of similar size/shape..
IE, if you did this

=SUMIF(A1:B10,10,D1:E10) it would work, because both arrays are the same size/shape.
It would sume column D where A = 10, + Column E where B = 10.

Try this instead..

=IF(G$4="a",SUMPRODUCT(('AOP Query'!$G$22:$G$440=$C30)*('AOP Query'!$I$22:$L$440)),0)

 

[Hoosier03]

That worked. Thank you very much.