Subtotal =0

  • Thread starter Thread starter canole
  • Start date Start date
C

canole

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 edit>paste special>add>ok>esc

Should now be good to go.


Gord Dibben MS Excel MVP
 
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.
 
Back
Top