how to use VBA to write " SUMPRODUCT(SUBTOTAL(3,OFFSET"............
=SUMPRODUCT(SUBTOTAL(3,OFFSET(EC1,ROW(EC1:EC4000)-ROW(EC1),0)),--(ISNUMBER(SEARCH(water,J1:J4000))),(EC1:EC4000))
many many many thanks for your help !!!!!HTML Code:
how to use VBA to write " SUMPRODUCT(SUBTOTAL(3,OFFSET"............
=SUMPRODUCT(SUBTOTAL(3,OFFSET(EC1,ROW(EC1:EC4000)-ROW(EC1),0)),--(ISNUMBER(SEARCH(water,J1:J4000))),(EC1:EC4000))
many many many thanks for your help !!!!!HTML Code:
Please Login or Register to view this content.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
You're welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks