I have tried every fx, combination of functions, formulas, etc and nothing
seems to work. Here is what I have and please someone tell me how to get a
numeric sum that isn't 0! Column B is IF Statement copied down Column B
=IF(a8=1234,"268.80",IF(a8=2345,"335.80",IF(a8="N/A","0.00",IF(a8=9876,"230.00",IF(a8=1010,"245.00", "0.00")))))

A B
8 1234 268.80
9 2345 335.80
9 N/A 0.00
10 9876 230.00
11 N/A 0.00
12 1010 245.00

Even with the correct number of (), changing the N/A to 0 and changing it in
the formula I still get 0 or #value or some other error message. I did try
sum(a8+a9) and that seemed to work but I have hundreds of cells to add and
that just won't be feasible.

Please HELP!!!!

abusymomforever