Hai Friends
In my attached sheet i want to calculate the month wise amount.
Hai Friends
In my attached sheet i want to calculate the month wise amount.
I solved it with a pivot table if that suits.
So use the SUMIFs() function?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
I want to solve it in formula, not table or chart
In D3, copied down:D3 can also be copied to G3 and down.=SUMIFS($N$3:$N$15,$M$3:$M$15,D$1,$L$3:$L$15,">="&C3,$L$3:$L$15,"<="&EOMONTH(C3,0))
Last edited by leelnich; 01-18-2018 at 05:02 AM.
Clicking the Add Reputation star below helpful posts is a great way to show your appreciation.
Please mark your threads as SOLVED upon conclusion (Thread Tools above Post # 1). - Lee
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks