SUMIF function combined with INDEX/MATCH

Hi,

Im wondering if there is a way to do the following;

In the attached sheet, I would like to be able to select a certain "Type" in column A e.g. AB2, and then in that particular row I would like to sum all values between a certain date range e.g. from Sep-14 to Nov-14, to give a total of 577 in this example.

I can do a SUMIFS with INDEX and MATCH to pick up a particular cell for a two way lookup, but cant seem to work out how to sum a range of the row values depending on the date range.

Is there a way of doing this?

Thanks
Nicki

Awesome! that works perfectly!

Thanks so much

Nicki

Hi FDibbins,

I used your formula and it worked great in my test data. But when i put it into production I get an error saying "Excel ran out of resources while attempting to calculate one or more formula. As a result, these formula's cannot be evaluated."

I assume this is because the data is too large for the SUMPRODUCT formula. Is there another formula I can use to get the same result?

Thanks
Nicki

Thanks to both of you. The issue definitely was the range. I had selected a whole column at the start of my formula. When i restricted the range it worked perfectly.

Cheers :-)
Nicki