Find and count each occurrence of a name - this is column A, then read the value from column B

Question

I need a formula that surpasses me and my Excel skills. I need to insert the number of times that a match is found in column A to column C, and then insert the total number of days for that person in column D. Can someone help?

Answer 1

In cell C2:

=COUNTIF(A$2:A$6,A2)

In cell D2:

=SUMIF(A$2:A$6,A2,B$2:B$6)

See also:

• COUNTIF
• SUMIF

Answer 2

Have you considered using a pivot table? This is a bit overkill, but greatly simplifies what you want to do. Assuming you are using Excel 2007:

• Select a range of data, including column labels.
• Go to Insert → [Tables] → PivotTable.
• " ", "".

PivotTable .

4. .
5. .
6. .

!