- Joined
- Mar 22, 2010
- Messages
- 1
- Reaction score
- 0
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)
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)