I'm trying to solve a problem with SOMPRODUCT formula.
The invoice nummer are entered by the manufacturer in a sheet. It is possible that the manufacturer enters the invoice number on different rows in a certain column.
I want to check the total amount of money on these invoices:
1. I want the total price excl. VAT (this is no issue and works)
2. I want the total price inclusive the right 6% and 21% of VAT
I guess it is an altering of the formula in cell B12 but I have no idea how to change it.
Bookmarks