Thread: SUMPRODUCT with TWO Conditions

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

Hi, I have just added the second condition (both condions must be met) to your formula.

=SUMPRODUCT(--(H9:H27="METHANOL")*(G9:G27="PLANT A"),SUBTOTAL(9,OFFSET(J9:J27,ROW(J9:J27)-MIN(ROW(J9:J27)),0,1)))


Hope it works.

Regards

Yes, this works!

Thanks!