Question

count cells in one column based on another column

Answer 1

Select a blank cell besides the pastedcolumn, type the formula=SUMIF($A$2:$A$24, D2, $B$2:$B$24) into it, and then drag its AutoFill Handle down the range as you need. And then we have summed based on the specified column.

HOPE IT'S HELP YOU