Try this in a different cell:

=count(g7:g135)

This counts the number of cells that contain numbers--it will not include the
cells that are text, but looks like numbers.

If you get something you don't expect (like 0), then one way to fix this is to:

select an empty cell
edit|copy
select G7:G135
edit|paste special|Add

Your text numbers will be converted to number numbers.

Yep. Just formatting the cells as Numbers (or currency or General or anything
else) won't change the value in the cell.

After you've converted the values to real numbers, you can apply the formatting
you want.

==========
If this doesn't help, maybe you've taken your data from a web site???

If you have, you could have those pesky HTML non-breaking spaces in the cells,
too.

David McRitchie has a macro that cleans up this kind of stuff:

http://www.mvps.org/dmcritchie/excel/join.htm#trimall
(look for "Sub Trimall()"

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Gaileen wrote:

I want to simply add several rows in a column - all containing currency
formatted cells. No matter what I do the total always appears as "0.00". My
formula seems pretty straightforward: =SUM(G7:G135). I've researched this
for the past 2 hrs. and even had our IT people involved, but no seems to be
able to help. I have a fairly large spreadsheet and don't want to have to
revert to my calculator. Anyone?

--

Dave Peterson