SumIF by Category and Date Range.

Hello,
How would I make it so that I can select from a dropdown list a category name and have only the total cost for a specific month and year for the category I selected.
So far, my formula works so that it calculates all category name entries and inputs the total for a specific month and year which is good but I want it do it only shows value for a chosen category name (Lodge 1) from a dropdownlist.

So far this is what I have
=SUMIFS(AH:AH,F:F,">="&$AK2,F:F,"<="&EOMONTH($AK2,0))

AH:AH Column consists of the Costs
F:F Column consists of the dates

Just add another criterion:

=SUMIFS(AH:AH,F:F,">="&$AK2,F:F,"<="&EOMONTH($AK2,0),range_containing_lodge_name,cell_containing_lodge_name_selected)

10 is not an Office version - please update your profile with the correct information. Thanks.

"=" & $E$1

$E$1 on its own would do.

Please update your forum profile as requested above - do NOT ignore moderation requests.

Unless there is an adjacent column with the lodge name on every row, it can't be done as Excel would not know which rows pertained to that lodge. You don't appear to have tried what we suggested ...

There are instructions at the top of the page explaining how to attach your sample workbook.

Thank you so much!
=SUMIFS(AH:AH,G:G,$AJ$2,F:F,"<="&EOMONTH($AK2,0))

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

Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

Hello sorry,

There is one glitch.

When it totals for the Month and year range all the rows after that month get the same value in column AL.

Only entries were made within Sept but after that every row gets the same value. So If there were entries for the month of October it will show that total number for that month and if there entries for the month of Sept it will show the total for that month.

Jan-21 $0.00
Feb-21 $0.00
Mar-21 $0.00
Apr-21 $0.00
May-21 $0.00
Jun-21 $0.00
Jul-21 $0.00
Aug-21 $0.00
Sep-21 $5.00
Oct-21 $5.00
Nov-21 $5.00
Dec-21 $5.00
Jan-22 $5.00
Feb-22 $5.00
Mar-22 $5.00
Apr-22 $5.00
May-22 $5.00
Jun-22 $5.00
Jul-22 $5.00
Aug-22 $5.00
Sep-22 $5.00
Oct-22 $5.00
Nov-22 $5.00
Dec-22 $5.00

Thank you so much!
=SUMIFS(AH:AH,G:G,$AJ$2,F:F,"<="&EOMONTH($AK2,0))

There are instructions at the top of the page explaining how to attach your sample workbook.

You missed a crucial criterion:

=SUMIFS(AH:AH,G:G,$AJ$2,F:F,">="&$AK2,F:F,"<="&EOMONTH($AK2,0))

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

Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

Thanks for the rep. PLEASE mark the thread as solved. Thanks.