Subtotal counting formula in cells

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

Guest

I have a worksheet that is using the subtotal function. Some of the columns
contain formula. In the columns containing formula when no filter is
selected the subtotal counts the data and also the cells containing the
formula ie =subtotal(3,B2:B50) shows a subtotal of 49 yet there is only text
in 10 of the rows. Is there a way for the subtotal to count only those cells
containing data and to ignore the cells containing just the formula?
 
If you mean that the range of cells contains text values, including
formula blanks "", try...

=SUMPRODUCT(SUBTOTAL(3,OFFSET(B2:B50,ROW(B2:B50)-ROW(B2),0,1)),--(B2:B50<
""))
Click to expand...

Hope this helps!
 
Back
Top