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.
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.
Last edited by pulkitsh; 05-01-2020 at 01:34 PM.
Welcome to the forum.
There are instructions at the top of the page explaining how to attach your sample workbook.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
i have attached the excel
with a pivot table.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
G2=sumproduct((month(b2:b100)=month(e2))*(year(b2:b100)=year(e2))*(b2:b100<>"")*(c2:c100))
Thank you very much, this is what i actually want.
Which one ?
Glad I could help.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Hi, i need one more formula.
Date and amount range is given. I need a formula which shows latest amount of latest date.
Show your question in an excel file. Please add manualy the expected result in the file.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks