SUM and Index Match with multiple criterias

[dsami0122]

I am trying to add a sum element to this formula to total sum of Column I based on matching the criteria found if match in J and A

=INDEX('Raw Data'!I:I,MATCH(1,(F1='Raw Data'!J:J)*(B2='Raw Data'!A:A),0))

 

[Fluff]

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

How about

=SUMIFS('Raw Data'!I:I,'Raw Data'!J:J,F1,'Raw Data'!A:A,B2)

 

[dsami0122]

Thank you worked perfect and I have updated my profile

 

[Fluff]

You're welcome & thanks for the feedback.