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

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
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.
 
Back
Top