Beckster

Sounds like the numbers are actually "text".

Re-formatting to numbers will not do the trick.

Select an empty cell formatted as General and copy.

Select your range of "numbers" and Paste SpecialAddOKEsc.

This will force the numbers to be numbers.


Gord Dibben MS Excel MVP

On Fri, 13 Jan 2006 01:40:02 -0800, "Beckster"
wrote:

I have a range of cells which retrurn a value if I use the Sum function.
They are all formatted as numbers. However if I use Sumif it always returns
zero, even if I leave the criteria blank to sum all cells.