Thread: Subtotal =0
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sean Timmons Sean Timmons is offline
external usenet poster
 
Posts: 1,696
Default Subtotal =0

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?