A Previous post has been very helpful for summing on an AutoFiltered List.
I used this formula and it worked well:
=SUMPRODUCT(--(H9:H27="METHANOL"),SUBTOTAL(9,OFFSET(J9:J27,ROW(J9:J27)-MIN(ROW(J9:J27)),0,1)))
NOW:
Is there a way to modify the formula so that I pick up two conditions to satisfy the SUBTOTAL on J9:J27?
For instance, I want to do the same SUBTOTAL on J9:J27 if BOTH H9:H27="METHANOL" and if G9:G27="PLANT A".
I've tried to moditfy the formula but have not had success.
Any suggestions would be greatly appreciated.
Thanks,
Akarupert
Bookmarks