Adding up Data Validated/Conditionally Formatted cells

Hello,

I am fairly new to Excel 2007.

I am creating a Work log, to track emails and phone calls I receive and make.

In my workbook, I have a column titled "Status". Each cell has a drop down box where you can select: Completed, InProcess, or over24hours. These cells have a conditional formatting on them, where Completed cells are highlighted in green, InProcess is yellow, and over24hours is red. This is to track how long a task has taken. I want to be able to add all cells that are "Completed" onto a separate worksheet. Same with "InProcess" and "over24hours".


I believe this is possible. Any guidance anyone can give will be greatly appreciated. If my thread has already been discussed, my apologies, I am new to the forums and will do my best to keep up.

Thank you!

I have attached your workbook with a count formula in Cells B2:B5.
I hope that was what you are after.

This is exactly what I needed! Thank you so much. The only function I didn't try was COUNTIF.

Thank you again, much good karma your way.

Another question. How do I get another cell, to count how many are "Completed" in a certain time span, like a week for example?

Do I just set my range to those dates?

This one was a bit beyond me so took some time to get it going, I think it works ok. You should see 2 cells to input the start and finish dates and a totals result.