Want to see if this is possible without writing a macro.

[JFulford84]

I have many rows of "repeated" data from different days with different values. Names of employees will repeat many times down column A with values I want to count in columns B, C, etc.

I have all my employees listed vertically in Range J1:J10 lets say.

I want to count all values in Column C where Range J1 matches the value in Column A.

I hope this makes sense.

I can accomplish this quite easily with a For Each statement but I want this to be a formula driven count.

Thank you.

 

[swst]

have a look at the COUNTIF function

Steve

 

[John Davis]

I have many rows of "repeated" data from different days with different values. Names of employees will repeat many times down column A with values I want to count in columns B, C, etc.

I have all my employees listed vertically in Range J1:J10 lets say.

I want to count all values in Column C where Range J1 matches the value in Column A.

I hope this makes sense.

I can accomplish this quite easily with a For Each statement but I want this to be a formula driven count.

Thank you.

Maybe:

=SUMIF(A1:A10,J1,C1:C10)