Hi!
Please can you help me with this cost calculator...
I would like the month columns in table2 to represent the associated month.
E.g. "+1mon" = "July" (Report date + 1month)
"+2mon" = "August" (Report date + 2months)
based on the month of the report date
I would like table 1,column6 onwards to duplicate the month name above
e.g. column6="July", column7="August" etc.
In table2 I would like to
show the summed "cost_total" columns from table4 in the associated month column of the materials row of table2
E.g. H5 should show the total for July (£342),H6 for August (£80) etc.
Thank you very much.
J
Bookmarks