How to have calc count duplicate names in sheet?

[rottik9]

The worksheet has date, name, vehicle, plate number and so on…I want to add a count column that will sum the number of time the name shows up.

[anon73440385]

Hello,

assuming

• name is in column B (according to your ordering date,name ...)
• values start in row 2

you may use: =COUNTIF(B:B,B2) in your counter column starting in row 2 and drag down the formula to all rows.

You could also define a Named Range (e.g. MYNAMES) for the names in column B and use: =COUNTIF(MYNAMES,B2)

Hope that helps.

If the answer helped to solve your problem, please click the check mark () next to the answer.