**NEVER** format cells as TEXT that will contain numbers.

Try this for your sum formula:

=SUMPRODUCT(--(B1:B10))

Adjust the range to suit.

--
Biff
Microsoft Excel MVP


"abusymomforever" wrote in
message ...
I am trying to get a numeric sum of column "B" but my reference cells are
in
column "A" which contain TEXT.
--
abusymomforever


"T. Valko" wrote:

Hard to tell what it is you're trying to do with this but to get your SUM
formula to work change your IF formula by removing the quotes from around
any of the numbers.

When you quote numbers Excel evaluates them as TEXT and in most cases,
these
can't be summed or added without some "trickeration".

--
Biff
Microsoft Excel MVP


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