AUTOSUM WON'T CALCULATE

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

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.
 
J

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
 
S

Shane Devenshire

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

=SUMPRODUCT(--Z1:Z100)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top