Multiple Count if statement with cross reference sheet

Options

I am trying to find a formula that will look up and sum all like numbers in primary column for each Item category and return the total for each item category it finds with an amount. Also looking for a cross reference formula for the sum of each Item category to a single cell in another sheet.

Example... Item 1 should have a sum of $20 but I have a sum formula referencing only the 3 lines below it. I cant seem to get a return on the formula but need to have the lines with sub categories


Best Answer

Answers