How to do countif in nested subtotals. Or is there a subtotalif f.

G

Guest

I would like to be able to use a countif function on a subtotal filtered
range. Something similar to a non-existent(?) subtotalif function. Thanks.
 
D

Dave Peterson

This was posted by George Simms a long time ago:

Headings in Row 1

=SUMPRODUCT((A2:A10="A")*(SUBTOTAL(3,OFFSET(A2,ROW(A2:A10)-ROW(A2),,1))))

Change the "A" to to "B" , "C" or a cell reference to count the others.
 

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