Refreshable Excel report for monthly GL
Refreshable Excel report for monthly GL
see the attached file for the 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.
Non-pivot table solution!
in D5
=SUMIFS(data!$D$4:$D$12,data!$C$4:$C$12,$C5,data!$B$4:$B$12,D$4)
Copy across and down
In G5
=SUM(D5:F5)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks