Ok maybe I'll try that, but what if I did something else.

What if say for example I wanted there to be a menu selection that when I click it, it gives me a total of the line items above it.

Then, I select another menu selection, and that one serves as a divider. You select "Attachment" in the 1st menu, then select "Shed" in the 2nd menu. No values Populate in the other cells.

Then I add items for that, and when I'm done with that section I can select total again, and it will add up all the numbers for that section only. See my attachment for an example

Attached Files

Invoice 1.1.xlsx (17.5 KB, 13 views)

Would require code.

That's because the equations are looking for a category (Attachment) and an item (Shed) that don't exist on the Data Tab. You would have to add them.

This brings up something I need to mention. As currently set up, all items need to be unique. For example, if you have "left-handed widget" in both the Flashing and the Edge categories, it will grab the data for the first one on the list. If they don't have the same Unit Cost, etc., you will have problems.