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

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
 
R

RagDyer

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.
 

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

Similar Threads

How to sum numbers in a range of a certain format? 7
Counting number of times certain Text Values appear 4
Count a certain value 2
counting how many times something happens in a week 4
Categorize certain times of day as other days 1
Find number of times certain words show up in a column 1
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Simple Count of certain cells 7

Top