This should be easy, but I'm missing something. I'll simplify for my example.
On a monthly budget sheet there two portals, one showing invoices for screwdriver purchases, another for wrenches (one table for each tool). Sometimes, both tools are bought from the same supplier, however.
I need to find a way to sum the invoice amounts on the portal rows by supplier, so if we've bought screwdrivers and wrenches from the same company we can pay them with one check.
Pulling out hair, thanks in advance!