Multiple Count if statement with cross reference sheet

Andrew Taglauer

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

Andrew Taglauer

@Anson Cheung Thank you this worked perfectly.

Anson Cheung

You can get the total of each category by:

=SUMIF([Primary Column]:[Primary Column], [Column4]@row, [Column2]:[Column2])

Also, if you want to reference another sheet, you can choose the "Reference Another Sheet" option below.

Andrew Taglauer

@Anson Cheung Thank you this worked perfectly.