SUMIFS + INDEX MATCH with repeated matches

Asked

Viewed 15 times

0

I have this table with repeated Tecs (column A), related to different products; I need to add the total of the week (from 19/4 to 24/4).. I’m using the formula below, but it only adds up the equivalent of the first line I find of the cat tec (line 3). How do I add the volume for all Tecs GATO?

=SUMIFS(INDEX(D:I;MATCH("Gato";A:A;0);0);D1:I1;"<="&"P4W4";D1:I1;">="&"P4W4")

excel

1 answer

0

Use the following formula, where K2 is the Tec, L2 is the start date and M2 is the End date.

=SUMPRODUCT(D3:I7*(A3:A7=K2)*(D2:I2>=L2)*(D2:I2<=M2)).

Browser other questions tagged excel

You are not signed in. Login or sign up in order to post.