need excel formula using if function


i have a range of date and amount spend.
i need a formula which can auto calculate the current month spendings and auto refresh after every month.

Excel formula: Sum by month | Exceljet

Try a Pivot Table

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Easiest way is to use a helper column. Attached is an example with different possible solutions:

You can define dynamic named range (dnDateMonth in my example), and use this to calculate the helper column DateMonth;
Or you can calculate month number directly in helper column - like in alternate helper column DateMonth2 - instead;
You can calculate current month like in named cell nCurrMonth, and use nCurrMonth in formula to calculate the amount for current month;
You can select the month using Data Validation List for cell nMonth, and use nMonth in formula to calculate the amount for selected month. You need a helper sheet (which can be hidden) to create a list of available months which is based on your date amount entries.

Attached Files

CurrentMonthSpending.xlsx (13.9 KB, 8 views)

Admins! Is it possible to delete the redundant post (this one - without attachment)

Easiest way is to use a helper column. Attached is an example with different possible solutions:

You can define dynamic named range (dnDateMonth in my example), and use this to calculate the helper column DateMonth;
Or you can calculate month number directly in helper column - like in alternate helper column DateMonth2;
You can calculate current month like in named cell nCurrMonth, and use nCurrMonth in formula to calculate the amount for current month;
You can select the month using Data Validation List for cell nMonth, and use nMonth in formula to calculate the amount for selected month. You need a helper sheet (which can be hidden) to create a list of available months which is based on your date amount entries.