AUTOSUM WON'T CALCULATE

  • Thread starter Thread starter Lori
  • Start date Start date
L

Lori

I have a column with the following formula in each cell. The formula
calculates correctly, but when I try to autosum or even enter =sum(z1.z100)
it keeps returning a 0 value.
=IF(Y2=1,"1099.23",IF(Y2=2,"824.42", IF(Y2=3,"100.00")))

I have about 1800 lines to add! Any suggestions?
Thanks!
 
Your values are text--not numbers:

=IF(Y2=1,1099.23,IF(Y2=2,824.42, IF(Y2=3,100.00)))

(dropped the "'s.)

And didn't you miss the else portion of the last =if() function.
 
HI Lori
Try removing your double quotes around the numbers
e.g.=IF(Y2=1,1099.23,IF(Y2=2,824.42, IF(Y2=3,100.00))

HTH
John
 
If you want to leave the quotes around the number then replace the SUM
formula with

=SUMPRODUCT(--Z1:Z100)
 
Back
Top