Good day,
I would like to solve this problem using formula, query, or pivot.
My company is issuing invoices. Most of them charge audit service fee and outlay together, and some of them only charge outlay.
I cannot think of a logic to distinguish them in the format I expected.
Please help.
Service fee and outlay.png
Last edited by Bobbie Kan; 08-15-2021 at 09:56 PM.
Isn't this the same as your other thread, with a slightly different layout? You are not allowed to duplicate threads on the forum, so mark this one as Solved and continue in your other thread.
Pete
No this is not the same.Originally Posted by Pete_UK
In google sheet I can use query function i.e.
={Query({Sheet1!A2:E},"Select Col1, Col2, Col3, Sum(Col5) Where Col1 Is Not Null Group By Col1, Col2, Col3 Label Sum(Col5) 'Invoice Total'"),Query({Sheet1!A2:E},"Select Sum(Col5) Where Col4 Contains 'Outlay' And Col1 Is Not Null Group By Col2 Label Sum(Col5) 'Outlay'"),Query({Sheet1!A2:E},"Select Sum(Col5) Where Col4 Contains 'Fee' And Col1 Is Not Null Group By Col2 Label Sum(Col5) 'Fee'")}.
I believe this is not available in Excel and Excel required a different solution.
So this one is not solved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks