Thread: COUNTIF: for the number of occurance of each term. ONE code for whole doc.

I looked for a long time through the past entries and couldn't find an answer for this specific situation.

I have a spreadsheet with multiple occurances of names in column A

A
green
green
green
blue
blue
white
white
white

and in column D I need a total of how many occurances of that name there are. that total needs to be listed in that row for that name specifically. There are many names on there currently and many will be added via copy/paste from another spreadsheet so i need one formula to paste into each row to cover ALL recurring names. Basically i need to enter in column D "=COUNTIF(A:A,"a term that would total the reoccurance of each name from the A column the corresponding D cell")

A D
green 3
green 3
green 3
blue 2
blue 2
white 3
white 3
white 3



The goal is to be able to copy/paste new entries into the spreadsheet, sort them by name, and have them automatically update the totals in each row even if they are new names. i guess it would be a "number of occurance of each term" code to cover all terms.

hope that makes sense. thanks.

Hi,

Welcome to the forum, this should do it for you

=COUNTIF(A:A,A1) auto-fill down