How can I count items in a filtered list?

  • Thread starter Thread starter Guest
  • Start date Start date
Biff

Your solution:

=sumproduct(subtotal(3,offset(b2:b100,row(b2:b100)-row(b2),0,1)),--(b2:b100="a"))

is brilliant. It has transformed some of my spread-sheets and made it possible to automate elements - and pass on to others to do - that I simply couldn't do before.

I am hugely grateful.

But: Could you posibly explain, or refer me to an explanation, on how it works. I'd love to teach it to others.

Yours

Henry Stewart, (e-mail address removed)
 
Back
Top