I want to sum each month's food costs for a particular year (N4:N15). N4:N15 will be referencing columns A, E and I and summing the costs from columns B, F and J.
Not sure if there is a function or way to translate month abbreviations so that they filter and match the raw data being entered in. For example, Aug = 18-Aug. I was using the MONTH() function but the abbreviation does not convert the month to a number but the raw data date does. Please advise. Do not go by the current formula in N11, I want to add Breakfast, Lunch and Dinner for any given month out of the year.
Regards,
T86157
Bookmarks