count numbers in column

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
 
J

Jason Morin

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top