View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Krashn Krashn is offline
external usenet poster
 
Posts: 2
Default Counting blank cells in a formula

I am trying to track progress with a percentage. In a range (V2:V90), I want
excel to count blank cells as 0 and if someone enters a date in the
worksheet, I want excel to count as 1. Then I would take and divide the
total in that cell range and by and overall total to arrive at a percentage.
I've tried many things and can't get it to work.

Here's an example of something I tried...
=(IF(ISBLANK(V2:V90),"0")(SUM(V2:V90)/F173))