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!!
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!!