COUNT IF MULTIPLE CRITERIA

davidhall80

Well-known Member
Joined
Jul 8, 2006
Messages
663
Does anyone know how to count if with multiple criteria. IF Column A says start and Column B says Today, how do I get a count of employees in column C. I would only count the employees that have "Start" in A and "Today" in B. Thanks
 

Some videos you may like

Excel Facts

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off

mbb4331

Board Regular
Joined
Dec 22, 2005
Messages
152
SUMPRODUCT(--(A1:A600="Start"),--(B1:B600="Today"),C1:C600)

Adjust ranges accordingly.
 

Watch MrExcel Video

Forum statistics

Threads
1,113,862
Messages
5,544,726
Members
410,630
Latest member
JFORTH97
Top