AUTOSUM WON'T CALCULATE

[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!

 

[Dave Peterson]

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.

 

[John]

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

 

[Shane Devenshire]

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

=SUMPRODUCT(--Z1:Z100)