Simple suumproduct query

Hi there,

With reference to the attached, can someone tell me how I can use the SUMPRODUCT formula to summarise the data contained in the 'Cost Detail' table, in the 'Cost Summary' table.

Requirement 1 of the formula must be that the product name/description in the 'Cost Summary' table matches exactly with the description in the 'Cost Detail' table
Requirement 2 of the formula must be that the cost is only summed in the correct date column of the 'Cost Summary' table - the correct date column being the month in which the cost is absorbed as per the 'Cost Detail' table

I don't think sumproduct is required, a basic sumif is all that is needed.

In E17 and filled down/right
=SUMIF($D$4:$D$13,$D17,E$4:E$13)

If the dates will not necessarily always be in the same order in both tables, then try this in E17 filled right/down

=SUMIF($D$4:$D$13,$D17,INDEX($E$4:$I$13,0,MATCH(E$16,$E$3:$I$3,0)))

Thanks Jonmo1,

I'm guilty of oversimplifying my problem. In the real version, the 'Cost Data' sheet is on another tab and the formula cannot be as simple as a SUMIF. It would need to be at least a SUMIFS formula so the date can be validated too. I forgot to mention this assumption in my post but this is the reason I'm looking for a SUMPRODUCT formula

The 2nd formula I posted will handle validating the date, just need to add sheet references..

=SUMIF('Cost Data Sheet'!$D$4:$D$13,'Cost Summary Sheet'!$D17,INDEX('Cost Data Sheet'!$E$4:$I$13,0,MATCH('Cost Summary Sheet'!E$16,'Cost Data Sheet'!$E$3:$I$3,0)))

This works perfectly, thanks!

You're welcome.