CODEWITHSUNDEEP
excelindexingsummatchvlookup
R.Ab
R.Ab

Reputation: 3

Index Match summation over multiple criteria

I am trying to do an index match summation over multiple criteria. I have figured out the index match, but cannot sum multiple things that have been found. An example table is linked below:

Example Table

I am trying to dynamically sum by Country across multiple time frames - e.g. For Argentina what is the sum of A between dates 2/1/2019 and 5/1/2019? I can do an index match to extract a specific number, but cannot sum.

Upvotes: 0

Views: 486

Answers (2)

dwirony
dwirony

Reputation: 5450

You can use a SUMIFS:

=SUMIFS(B3:G3,B2:G2,"A",B1:G1,">=2/1/2019",B1:G1,"<=5/1/2019")

img1

Upvotes: 0

Scott Craner
Scott Craner

Reputation: 152450

Use INDEX/MATCH to return the correct row to a SUMIFS:

=SUMIFS(INDEX(1:1000,MATCH("Argentina",A:A,0),0),1:1,">=" & Date(2019,1,2),1:1,"<=" & date(2019,1,5),2:2,"A")

Upvotes: 2

Related Questions