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

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

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

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.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
wrote in message
oups.com...
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