get count from multiple rows in one cell by unique identifer

Suz

I have a sheet "test" with a column named DND that has multiple rows with the same cell data. See my pictures, for example there are three lines for "location 1". I need to count the totals in the "Count" column for that location and put the result in my second sheet named "test2".

So, on "test2" sheet for "location 1" the answer should be 3.

Paul Newcome

Try a SUMIFS.

=SUMIFS({Count Column}, {Location Column}, @cell = DND@row)

Suz

I figured out how to do it with COUNTIFS