Count occurences based on name

[djsouljah]

Hi Team,

I need some help with a formula.

I have a workbook where employees enter their activities throughout the day with other employees.

In my workbook i have 2 sheets. in sheet 2 I need a formula that counts the number of times an employee has done a specific activity.

The name of the employee is in Sheet1 Column A and the activity they do is in Sheet1 column D.

I tried to use the SUMIF formula but winding up with a result of 0 every time..I think it's because the activities are not actually numbers to be able to SUM.

Can you enlighten me on how I can resolve this please.

Thank you !

[Olly]

Sounds like you need to use COUNTIFS, but it will be easier to help if you upload your workbook.

[Tony Valko]

Try something like this...

=COUNTIFS(Sheet1!A:A,"Name",Sheet1!D:D,"Activity")

Replace Name and Activity with the actual criteria or cell reference.

[djsouljah]

Great Tony's formula worked ! Thanks guys !

[Tony Valko]

You're welcome. Thanks for the feedback!