sum if questions

[Guest]

Hi, I am having a memory block !
I need to sum costs in colum C, if column A = x and column B = Y.
n
When using sumif i appear to count all costs in column C not just the ones
required.. any suggestiong where i'm going wrong ??

 

[Pete_UK]

You can only use one condition with SUMIF. Either use SUMPRODUCT or
SUM(IF(...)) entered as an array formula.

Hope this helps.

Pete

 

[Dave Peterson]

=sumproduct(--(a1:a100="x"),--(b1:b100="y"),c1:c100)

Adjust the ranges to match--but you can't use whole columns.

=sumproduct() likes to work with numbers. The -- stuff changes trues and falses
to 1's and 0's.

Bob Phillips explains =sumproduct() in much more detail here:
http://www.xldynamic.com/source/xld.SUMPRODUCT.html

And J.E. McGimpsey has some notes at:
http://mcgimpsey.com/excel/formulae/doubleneg.html