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
Bookmarks