ExcelBanter - How do you count number of times Fred Smith appears in a list

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How do you count number of times Fred Smith appears in a list (https://www.excelbanter.com/excel-discussion-misc-queries/161034-how-do-you-count-number-times-fred-smith-appears-list.html)

Geoff

How do you count number of times Fred Smith appears in a list

I'm trying to count the number of times a sales persons name (Fred Smith)
appears in several columns of a work sheet.

Matt

How do you count number of times Fred Smith appears in a list

=COUNTIF(Data Range, "Fred Smith")

"Geoff" wrote:

I'm trying to count the number of times a sales persons name (Fred Smith)
appears in several columns of a work sheet.

All times are GMT +1. The time now is 08:57 AM.