Must be a simplier formula?

[wafw1971]

Good Afternoon All

Thank you for you help in advance:

I have a budget spreadsheet where i need to collate monies according to month it was purchsed i have come up with:

=IF(Consumables!$A$7=J4,Consumables!$I$7,0)+IF(Consumables!$A$8=J4,Consumables!$I$8,0)+IF(Consumables!$A$9=J4,Consumables!$I$9,0)+IF(Consumables!$A$10=J4,Consumables!$I$10,0)

but have to add a new IF statement for each month, there must be an easier way something like this =IF(Consumables!$A$7:$A$18='Master Allocation'!E4,Consumables!$I$7:$I$18,0) am i on the right track?

Thanks

Wayne