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


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


      Open in new window

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


      Open in new window

      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
      pdvsaProject financeAuthor Commented:
      perfect.  Greatful for your help.
      Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
      You're welcome. Glad I could help.
      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.