Count how many times a certain value is in a certain range

  • Thread starter Thread starter paul.verwilt
  • Start date Start date
P

paul.verwilt

Hi There,

I would like to know (find a formule) how many times a certain value or
variable is entered in a certain range. I'm using this for a planning
spreadsheet that I'm making in which I would like to make sure that a
resource is only planned on one project/task per day. I would like to
count the number of times a resource is entered over the projects per
day and compare it to 1.

Thanks in advance.
Paul
 
Use the Countif() function.

If your range was A1 to A50,
And you entered your variable in B1,
Then try this:

=COUNTIF(A1:A50,B1)

All you need to do is change the value in B1 to get a different count.

You also could enter a list of variables in Column B, and then with this
formula in C1:

=COUNTIF(A$1:A$50,B1)

Copy it down, so you would have a register of values and counts.
 
Back
Top