G
Guest
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))
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))