Is there a way to sum IF "x" AND "y" are TRUE?
K Kevin Jun 4, 2004 #2 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
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
D Dave R. Jun 4, 2004 #3 try =SUMPRODUCT((A1:A10="x")*(B1:B10="y"),C1:C10) c1:c10 what you want to sum.
D Dave R. Jun 4, 2004 #4 Kevin, if I'm not mistaken, that would either sum all the numbers, or nothing, which is usually not what people are looking for..
Kevin, if I'm not mistaken, that would either sum all the numbers, or nothing, which is usually not what people are looking for..
