Conditional tallies

[megancatherine]

Hi - new to posting but have read these boards for a while. Needed a semi-quick answer and didn't want to search through all the threads like i usually do looking for an answer.

I'm building a tracking sheet for a contracts process we have at work. Basically there can be 6 conditions for any contract that we're working on: "Reviewed", "Drafted", "On Hold", "Out for Signature", "Cancelled", and "Done". I've created a quick dropdown box using the Validation Allow: List feature for these 6 categories. For each contract we're working on, the idea is to pick from the list of 6 status conditions.

What I'd like to do is build a tally for the conditions, so at any given time we can easily find out how many we have "Reviewed", "Drafted" etc. Is there a way to use a formula to say that in cells A4:A100, count the number of ones that say "Reviewed" etc.. and report it to me in a cell.

Basically what I want it to look like is
Reviewed: N
Drafted: N
On Hold: N

Etc.

Thanks!!

 

[mvptomlinson]

Hi megancatherine,

Let's say you have the words Reviewed, Drafted, On Hold, Out for Signature, Cancelled and Done in cells B1:B6. In C1 use the formula:

=COUNTIF($A$4:$A$100,B1)

Fill that formula down to C6 and you'll get a count for each value in the range A4:A100.

 

[Andrew Poulsom]

You can use:

=COUNTIF(A:A,"Reviewed")

The string "Reviewed" can be replaced with a cell reference.

 

[megancatherine]

Exactly what I needed - worked perfectly.

Thanks a bunch!

 

[lenze]

OR use a Pivot Table for A4:A100

Gives you all of them at once.

lenze