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!!
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!!