count numbers in column

  • Thread starter Thread starter jcg
  • Start date Start date
J

jcg

I am writing a schedule. I want to total the number of times a 6, an
8, a 10, a 1 a 2, a 4 shift is scheduled. I can't figure out how to d
it. What I have is a column for each day of the week. I want a cel
below the last person in the list to show how many people are schedule
for the above shifts. Help would be appreciated.

Thank
 
Either use this for individual numbers

=COUNTIF(A1:A100,4

or for all of them

=SUM(COUNTIF(A1:A10,{1,2,4,6,8,10})

HT
Jaso
Atlanta, G
 
Back
Top