count only cells with contents?
Posted by keke on September 05, 2001 3:46 PM
Hi, folks. Still messing with the stats on this production tracking system I'm putting together. Here's the latest quandary:
Column "O" contains the date a job is completed. If the job is still outstanding the cell in that row for column O is blank. I need to keep a running total of jobs completed.
There is a function to look for blank cells. I want Excel to do the opposite: look for cells with contents only, and then count those cells. I was thinking along the lines of combining COUNTIF and ISNUMBER but I can't seem to hit the right combination. Or maybe I'm completely toast. :-)