Subtotal counting formula in cells

J

jimar

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?
 
D

Domenic

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<

Hope this helps!
 

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

Top