Forum Discussion
I've got the SUMIFS blues
I posted the same discussion a couple days ago, but don't see it on here anymore. Thought I'd try again. I'm using Microsoft 365 Apps for Business version of Excel on a PC. Background: I'm making a...
Hi MBMAdmin
I do not have a formula solution for you. But instead, I propose Power Query.
In the attached file you find my solution. The list with transactions has been converted into a formatted table.
Beside, there is a reference table with the transaction fees per code.
Both tables are then imported into Power Query and transformed, so the individual fees can be calculated. The results are directly loaded from Power Query into a pivot table.
All you have to do is maintain the table with the transaction fees and then do a refresh on the pivot table once there are new payments made.
Kind regards,
Martin