count based on range and unique value

[boltsg4]

Tried to attach example...wouldn't let me

Trying to figure out how many times an employee, (i.e. Eric or Dave) falls between the parameters 0-5 and greater than 5.

thanks for your help!

A B
Eric 1
Eric 5
Eric 3
Eric 6
Dave 4
Dave 7
Dave 8
Dave 1

[FDibbins]

Take a look at using the countifS() function for this

Tried to attach example...wouldn't let me

To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

[Tony Valko]

Something like this...

Assuming no negative numbers.

=COUNTIFS(A2:A10,"Eric",B2:B10,"<=5")

=COUNTIFS(A2:A10,"Eric",B2:B10,">5")

[boltsg4]

perfect...thanks!

[Tony Valko]

You're welcome. Thanks for the feedback!