Summing the monthly costs of a project

Hi,

I am relatively new to excel.

I have a workbook that consists of two tabs; Tab1 is a table to display the data in tab2, Tab2 contains columns of data that has been exported from another programme, the exported data is updated on a weekly basis so the row locations may change but the columns will always remain the same.

The columns within the table tab (Tab 1) are:
PROJECT NUMBER PROJECT NAME January February March April May June July………

What I am trying to do is calculate the total (current) cost of each project for each month, I know the formula =SUMIF('IFS '!I:S,A8,'IFS '!S:S) sums the total cost for each project so that part works but when I try to specify only find the costs for Project A in April I keep getting #value

This is the formula I am using

=SUM(IF((MONTH('IFS'!C2:C200)=4),('IFS '!I:S,A8,'IFS '!S:S),0))

=SUM(IF((MONTH('IFS'!C2:C200)=4) – to look up all costs for April but I keep getting #Value

Column C in (tab 2) is a date, the format is 01/04/14 I did try searching for “April” but it would not find it after I had changed the format as Excel still saw the date as 01/04/14

Column S in (tab 2) is the cost

Any advice on how to fix the formula is much appreciated.

Please ask any questions if I have not explained myself very well and thank you in advance for your help.

Sixthsense thank you for your prompt reply
I have tried using the formula you have given and when I add it to the spreadsheet first it opens a folder searching for a file and then when I click “cancel” it comes up with #Ref what would I need to change do you think.
Sorry as I said I am still relatively new to excel.

Special-K - Thank you for your reply but I need it to search for the monthly costs incurred for each project number.

Kind Regards

Thanks for all your help