Error with Conditional sum

[kristoffransen]

Does the conditional sum work when you use it on fields that contai
formulas? I used it with the example below but got a zero instead o
the result wanted. I said to add all the Z-values which had a Y valu
of less than 22. This is the case when X=4. So the result should hav
been 32 instead of 0.


X Y= 4X+5 Z= 5X+12

4
6

 

[Frank Kabel]

Hi
you may post your SUMIF formula to analyse what has gone wrong as SUMIF
will work on formula results. You could try the following:
=SUMIF(Y1:Y100,"<22",Z1:Z100)

Frank

 

[Tom Ogilvy]

Yes, it does work on cells with formulas. What does your formula look look
like (your conditional sum formula)