I updated my previous example accordingly your last workbook.



Again it is unclear for what the column TaxiHead is needed! I added it, and used it in calculations, but currently you can leave it out, and nothing changes!

Based on name, the column Reason probably contains some texts. As you want this text to be displayed too, I had to add a helper column RowNo into PriceList Table, and instead of SUMIFS() had to use INDEX() to retrieve result data from PriceList.

An advice - never place different Tables onto same sheet. When you do this, you practically restrict yourself from adding rows into Tables, or deleting them!

Attached Files

CalulationExample.xlsx (19.8 KB, 8 views)