Error with Conditional sum

  • Thread starter Thread starter kristoffransen
  • Start date Start date
K

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
 
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
 
Yes, it does work on cells with formulas. What does your formula look look
like (your conditional sum formula)
 
Back
Top