Formlua Help

[ai1094]

Hi, I need help writing what I think should be an easy formula. I am trying to get a count of people based on their department. The column that I want to count is located in Column AM. I need a formula that will count the number of entries that contains the department's name (ex. Human Resources). How would I go about writing that formula?

Thanks!

 

[Fluff]

Have a look at countif
https://exceljet.net/excel-functions/excel-countif-function

 

[Scott Huish]

It's a COUNTIF formula:

Excel 2010
	AG	AH	AI	AJ	AK	AL	AM
1	Human Resources	11					Human Resources
2	Sales	1					Human Resources
3							Human Resources
4							Human Resources
5							Human Resources
6							Human Resources
7							Sales
8							Human Resources
9							Human Resources
10							Human Resources
11							Human Resources
12							Human Resources
Sheet1

Cell Formulas
Range	Formula
AH1	=COUNTIF(AM:AM,AG1)
AH2	=COUNTIF(AM:AM,AG2)

 

[ai1094]

Thanks guys, this was helpful!

 

[Fluff]

Glad we could help & thanks for the feedback