Thread: Add values based on month using Sumifs or any other formula

I am trying to sum the values based on the month ranges,

I have created "Named Formulas"

1) Dates2012 --> A:A which has my date inputs
2) Expenses2012 --> B:B Which has my expenses

I want to add the expenses based on month

I am using

=SUMIFS(Expenses2012,Dates2012,">=01-01-2012",Dates2012,"<=01-31-2012")
=SUMIFS(Expenses2012,Dates2012,">=02-01-2012",Dates2012,"<=02-28-2012")
=SUMIFS(Expenses2012,Dates2012,">=03-01-2012",Dates2012,"<=03-31-2012")
=SUMIFS(Expenses2012,Dates2012,">=04-01-2012",Dates2012,"<=04-30-2012")

and so on

I need your help ...

Instead of hard coding the dates is there a way I can use Month().

In the above way I need to change the dates manually(static), please guide me if I can use any Dynamic way.

I am unable to attach file, please help

Thanks & Regards

Jamal A M

Hi Jamal and welcome to the forum.

You can use SUMPRODUCT for this.

=SUMPRODUCT(((MONTH($A$2:$A$10)=MONTH(E2))*($B$2:$B$10)))

Take a look to the example.

Hope to helps you.

Glad to helped you Jamal

Thanks for the feedback and also for the reb*

So pls mark your thread, as SOLVED.