Formula to add 2015 and formula to add specefic months

[nasoor123]

Dear All,

I need help please. In the attached file, can someone please help me with formulas for the following:

1- A formula that adds column G for cells in column H containing 2015 only given that I cannot change the format of the cells of column H.
2- A formula that adds column G for cells in column H for months from 2.2015 to 6.2015 only given that I cannot change the format of the cells of column H.

Many thanks and appreciate your help.

Nasser

[Pete_UK]

This will give you the answer to 1:

=SUMPRODUCT(--(RIGHT(F2:F25,4)="2015"),G2:G25)

and this one for 2:

=SUMPRODUCT((F2:F25>2)*(F2:F25<7)*(RIGHT(F2:F25,4)="2015"),G2:G25)

Hope this helps.

Pete

[nasoor123]

Thanks very much. this is very helpful Pete.

[Pete_UK]

You're welcome - glad to help.

If that takes care of your original question, please select Thread Tools from the menu above your first post and mark this thread as SOLVED.

Also, you might like to click on the small "star" icon located in the lower left corner of a post that you have found to be helpful (not just in this thread - for any post that has helped you).

Pete