Conditional tallies

megancatherine

New Member
Joined
Jul 24, 2008
Messages
2
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!!
 

Some videos you may like

Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.

mvptomlinson

Well-known Member
Joined
Mar 10, 2008
Messages
2,638
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

MrExcel MVP
Joined
Jul 21, 2002
Messages
73,092
You can use:

=COUNTIF(A:A,"Reviewed")

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

lenze

Legend
Joined
Feb 18, 2002
Messages
13,690
OR use a Pivot Table for A4:A100

Gives you all of them at once.

lenze
 

Watch MrExcel Video

Forum statistics

Threads
1,123,480
Messages
5,601,911
Members
414,482
Latest member
morkar

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top