Sum row values based on horizontal and vertical criteria

Hello,

I am looking to sum values in a row based on a horizontal month range and vertical name range.

Here is what I am trying to achieve:

1 2 3 4 5

Michael $24,000 $36,000 $24,567 $45,000 $36,900
Jerry $27,000 $39,090 $55,567 $85,000 $39,900
Sandra $24,000 $36,000 $24,567 $45,000 $36,900
Michelle $24,000 $36,000 $24,567 $45,000 $36,900

I want to be able to sum based on the month range.

For example, If I want to know what the value is for Sandra in months 3-5 ($24,567 + $45,000 + $36,900)
So everytime I play around with the range it should give me the sum of those values.

I tried an index match match function but I could only do it for a specific month not a range.

This was the formula I used : =INDEX(Quota!$A$3:$P$29,MATCH('Summary by Rep'!A7,Quota!$A$3:$A$29,0),MATCH('Summary by Rep'!B4,Quota!$A$3:$P$3,0))

Any help would be greatly appreciated!

You could use SUMPRODUCT for this. For example:

Formula:

Please Login or Register  to view this content.

See attached where rather than hardcoding the parameters I've referenced cells with the details in so you can change them easily to update the result.

BSB

This works perfectly! Thank you so much!!!!!!!!!!!!!!!

Happy to help.

BSB