Summing the cost of a project by month

Hi

Apologies I asked this question this morning and it was very kindly answered but I have now done something to the code and can not get it to work the previous thread I have marked as solved.

What I am trying to do is total all of the cost that is related to each project for each month the formula I am using is

=SUMPRODUCT(--(MONTH('IFS '!C2:C200)=4),--('IFS '!I:S=A8),'IFS '!S:S)

I have attached a copy of the spreadsheet

Thank you for any help

Perhaps a Pivot Table?

I'd go with Pivot Table too but if you want to fix your formula

=SUMPRODUCT(--(MONTH('IFS '!$C$2:$C$1000)=4),--('IFS '!$I$2:$I$1000=A7),'IFS '!$S$2:$S$1000)

The number of rows in each argument need to be the same or you'll get an error. If the range is too big, it'll take too long to calculate.