Subtotal not calculating fully

  • Thread starter Thread starter marvontherim
  • Start date Start date
M

marvontherim

I have a simple function to subtotal a long column.
The function is =SUBTOTAL(9,P7:P850)
some of the cells in the column have values but don't add to th
total.
Any help would be appreciated
 
Some of the values are most likely entered as Text. Coerce them to
numbers by selecting an empty cell, copying it, selecting your numbers
and choosing Edit/Paste Special, selecting the Values and Add radio
buttons.
 
Back
Top