Sum data for a given range of months (if months are number or text)

Experts,

if given:
1/1/2016   1/2/2016  2/1/2016  2/15/2016  3/1/2016
with costs of
10/20/40/50

    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....
      EE-SumIF-Dates.xlsx
      pdvsaProject financeAsked:
      Who is Participating?
       
      Subodh Tiwari (Neeraj)Connect With a Mentor Excel & VBA ExpertCommented:
      If the dates criteria are in row7, try this....

      =SUMPRODUCT(($B$5:$ALD$5<>"")*(MONTH($B$5:$ALD$5)=MONTH(B$7))*$B$6:$ALD$6)
      

      Open in new window

      0
       
      Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
      See if this works for you...

      =SUMPRODUCT(($B$5:$ALD$5<>"")*(TEXT($B$5:$ALD$5,"mmmm")=B$15)*$B$6:$ALD$6)
      

      Open in new window

      0
       
      pdvsaProject financeAuthor Commented:
      nice.  it worked for the months in text.
      Would you have a suggestion for the months in digit format (ie 1/1/2016)

      thank you
      0
       
      pdvsaProject financeAuthor Commented:
      perfect.  Greatful for your help.
      0
       
      Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
      You're welcome. Glad I could help.
      0
      Question has a verified solution.

      Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

      Have a better answer? Share it in a comment.

      All Courses

      From novice to tech pro — start learning today.