In Q5 I want the total of charges of unit number 1000 for January. For Example the dates in C12 until B16. I managed to find the total charge in K8. But I want it to find a formula that its defined per month.
So in Q5 I want ofcourse 17-1-2013 until 31-1-2013 in Q5, then entire february in R5 etc. Thanks in advance!
monthly charge.xlsx
Why not use a pivot table, with [Unit] in rows, [In] Grouped by Years / Months in columns, and Sum of [Charge] in values...
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks