How to have calc count duplicate names in sheet?

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.



  • 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 (:heavy_check_mark:) next to the answer.