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.

Lori wrote:

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

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
"Lori" wrote in message
...
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!

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

=SUMPRODUCT(--Z1:Z100)

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Lori" wrote:

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!