summing with an if statement

[Matt]

Is there a way to sum IF "x" AND "y" are TRUE?

 

[Kevin]

Try this:

IF(AND(X=True,Y=True),sum(A1:A5),<falsestuff>)

<falsestuff> is what you want to do if either of them are
false.

or

IF(and(x=true,Y=True),sum(A1:A5))

if you just want to leave the cell empty if either
condition is false.

Good Luck,

Kevin

 

[Dave R.]

try

=SUMPRODUCT((A1:A10="x")*(B1:B10="y"),C1:C10)


c1:c10 what you want to sum.

 

[Dave R.]

Kevin, if I'm not mistaken, that would either sum all the numbers, or
nothing, which is usually not what people are looking for..