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
Bookmarks