Yearly cost breakdown per item for multiple items: Issues with formula.

[skyping]

All,

I’m having a bit of an issue finishing off a project and I hope that you experts can guide me in the right direction!!!

I have 3 worksheets, one for costs, one for invoices and one called yearly summary.

The issue is with the yearly summary worksheet regarding calculating how much Fuel, Parts, etc (columns J:R) are in each period defined by the drop down in cell I2.

Whilst I have managed to work out a formula to sum the incomes and expenses for each month (see Columns E:G, including corresponding number of invoices or receipts), I can’t seem to work out how to do it for the various items which are calculated from the appropriate column of worksheet Allcosts (M:U). These items are results of additional formula whereas the Columns E and G are simply numerical, which I believe may well be the problem.

In the attached workbook, I have removed all sensitive data as well as lots of other code which aids other functionality, but has no effect on these calculations.

Therefore, can someone please help and see where I am going wrong for the values currently showing #VALUE! in worksheet yearly summary worksheet columns J:R.

I hope this is clear, and thanks for looking!!

Skyping

[tim201110]

=sum(if(AllCosts!M$18:M$2010<>"",(month(AllCosts!$B$18:$B$2010)=$B6)*(year(AllCosts!$B$18:$B$2010)=$D6)*AllCosts!M$18:M$2010)) as SCE

[skyping]

Thank you tim201110. SOLVED