Remove part of formula

[Blake0920]

Trying to remove part of a formula but can't seem to get it right.

This is the current formula =SUMPRODUCT((SUBTOTAL(3,OFFSET(L4,ROW(L4:L8)-ROW(L4),)))*(R4:R8="C3CAN")*(H4:H8)*(TEXT(S4:S8,"mmm-yy")="Jan-22")) and I would like to remove the L row/field.

Every time I try to adjust, it keeps giving me invalid errors.

I would like to remove ROW L (as seen in the picture) + what is in bold below.

=SUMPRODUCT((SUBTOTAL(3,OFFSET(L4,ROW(L4:L8)-ROW(L4),)))*(R4:R8="C3CAN")*(H4:H8)*(TEXT(S4:S8,"mmm-yy")="Jan-22"))

Thank you!!

 

[shift-del]

Hi

You have to remove the whole SUBTOTAL() part.

=SUMPRODUCT((R4:R8="C3CAN")*(H4:H8)*(TEXT(S4:S8,"mmm-yy")="Jan-22"))

 

[Blake0920]

Thank you very much!! Worked