1/1/2016 1/2/2016 2/1/2016 2/15/2016 3/1/2016
with costs of
Sum the costs for these months:
if month is text:
January, February, March
if months are given in month format:
1/1/2016; 2/10/2016; 3/25/2016
What is the formula to sum those costs based on the months?
I am not sure if I should use SUMIF (as an array) or SUM PRODUCT.
Please see attached spreadsheet with necessary data and the formulas I have used but note they are not correct formulas.
thank you in advance....