Formatting Bill of Materials

[ArviLaanemets]

An example how organize data entry and get bill details table for any chosen bill.

Columns in Tables having formulas are colored differently. In case you feel there is no need for users to see some of calculated columns, you can hide them. Some calculated columns are helper columns, and are needed to allow to use SUMIFS()/COUNTIFS() formulas.

I used Defined Tables in my example. In Defined Tables (From menu: Insert>Table), formulas and formats are automatically expanded whenever a new row is added (assumed the formula/format remains same for entire column). And whenever you change Table or Column Name, those changes are automatically reflected in all Table formulas over entire workbook.