How to count in a list

[althea]

What formula will give me a count of how many cells in a list meet certain criteria? I need a summary of how many times each name has an entry for "days off". For example:
Days Off
John 1 **This is where I need the formula**
Chris 1 **For example, in row 1 the answer would be 3
Jason 2 **Answer in row 2 would be 5
John 2
Chris 4

Thanks so much!

 

[tony813]

Hello...althea..

you may use the SUMIF FUNCTION

EXAMPLE:

COLUMN 1 COLUMN 2
JOHN 5
JOHN 4
TONY 1
CINDY 1

=SUMIF(A1:A4, "JOHN", B1:B4) GIVIES YOU THE RESULT 9

THIS IS THE SYNTAX: SUMIF(range,criteria,sum_ranng)

Hope this helps....

Tony_813

 

[ETID]

Or the dsum() function ...