Hi Team,
Need your assistance in the excel budget that I am making. I need to get the sum of each category on a monthly basis.
What I have:
- 3 sheets named as: Summary computation, Cash In, and Cash out
- 5 categories in Cash Out: Credit Card, Bills, Grocery, Kids, and Others
What I want to see in Summary Computation:
- To display the total amount of of each category per month
- example: total Credit Card amount for the month of May, total Credit Card amount for June. and all following months...
- same formula for other categories
Formula that I have:
=IF(MONTH(CashOut!$A$2:$A$1048576)=5,SUMIF(CashOut!$B$2:$D$1048576,SummaryComputation!A2,CashOut!$D$2:$D$1048576),0)
- CashOut!$A$2:$A$1048576 is the date column
- CashOut!$B$2:$D$1048576 is the range of category upto amount
- SummaryComputation!A2 is the specific category in "Computation sheet" such as "Credit Card"
- CashOut!$D$2:$D$1048576 is the amount
This formula displays total amount of "Credit Crad" for whole year instead of the month of May only
Please help me to solve my problem. really need this to be done the soonest. thank you.