I am adding a subtotal to a report. All of my subtotals equal 0.
3.50 700 The Responsible Manager - FFS Class 1
4.00 703 Ethics & Employee Conduct - FFS Class 4
4.00 704 Managements Kitchen Sink - FFS Class 5
0
The formula looks right =SUBTOTAL(9,C2379:C2396)
I've tried to reformat the cells. I just don't get it. Can anyone help?

If your data is not real numbers but text, you will get a zero.

Simply re-formatting will not change these "numbers".

Format all to General.

Copy an empty cell.

Select the range of "numbers" and editpaste specialaddokesc

Should now be good to go.


Gord Dibben MS Excel MVP

On Thu, 22 Oct 2009 12:50:09 -0700, canole
wrote:

I am adding a subtotal to a report. All of my subtotals equal 0.
3.50 700 The Responsible Manager - FFS Class 1
4.00 703 Ethics & Employee Conduct - FFS Class 4
4.00 704 Managements Kitchen Sink - FFS Class 5
0
The formula looks right =SUBTOTAL(9,C2379:C2396)
I've tried to reformat the cells. I just don't get it. Can anyone help?

Are the cells formatted as text? If you have error checking, you will see a
green triangle in the cell. If this is the case, you can highlight the
cells, click the Exclamation point and convert to Number. Or, you can enter 1
in a blank cell, copy this cell, highlight your C2379:C2396 cells, paste
special/multiply.

"canole" wrote:

I am adding a subtotal to a report. All of my subtotals equal 0.
3.50 700 The Responsible Manager - FFS Class 1
4.00 703 Ethics & Employee Conduct - FFS Class 4
4.00 704 Managements Kitchen Sink - FFS Class 5
0
The formula looks right =SUBTOTAL(9,C2379:C2396)
I've tried to reformat the cells. I just don't get it. Can anyone help?