Subtotal Function

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Why would the subtotal function delete the end of a worksheet? In other words
why would it not subtotal the entire worksheet and only a portion?
 
If you are refering to the SUBTOTAL worksheet function, then it calculates to
the Range specified therein. If you have what appear to be numbers within
the specified range which do not calculate, then they are probably formatted
as TEXT rather than numbers and just "look" like numbers.

Vaya con Dios,
Chuck, CABGx3
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Average of Subtotals in Pivot Table 0
subtotal, match? 10
Does Excel have a @grandtotal function like Lotus 123 2
Subtotaling 3
function question 2
Function Question 8
SubTotal 1
Multiple Subtotal Placement 2

Back
Top