Excel Counting non blank cells -

-

i having no luck trying count non blank cells in excel. have tried multiple formulas , keep getting inaccurate data. here situation:

i creating preventative care list physicians (i have 4) created list of patients have received letter re: prev. care , inputting needs second letter , has results. results negative, positive. have list set in alphabetical order on patients last name , have physician initials in other column. want check see percentage of each doctors patients have done prev. care. want calculate separately. unfortunately, cells no in order. have tried knowledge.

help!

this give how many blank cells have. can deduct total number of cells in column, or use directly compute percentage (1 - x) x percentage of blank cells.

 =countblank(<your column>)

e.g:

 =countblank(a1:a10)

Comments

Post a Comment

Popular posts from this blog

Unable to remove the www from url on https using .htaccess -

-
i want remove www site url. ie. https://www.domainname.com.au https://domainname.com.au . i have tried various .htacces code nothing work me. here present code remove www http not work https. rewriteengine on rewritebase / rewritecond %{http_host} ^www\.(.*)$ [nc] rewriterule ^/(.*)$ http://%1/$1 [r=301,l] rewritecond %{https} off rewriterule ^(.*)$ https://domainname.com.au/$1 [r=301,l] rewriterule ^code-of-conducts/(.*)/$ code-of-conducts.php?type=$1 rewriterule ^parents/post-a-job/(.*)/edit/$ parents/post-a-job.php?action=edit&id=$1 rewriterule ^parents/post-a-job/(.*)/$ parents/post-a-job.php?job_type=$1 rewriterule ^parents/open-jobs/(.*)/delete/$ parents/open-jobs.php?action=delete&id=$1 rewriterule ^parent-profile/(.*)/$ parent-profile.php?id=$1 rewriterule ^parents/job-details/(.*)$ parents/job-details.php?applied_id=$1 rewriterule ^sitterprofile/(.*)/$ sitterprofile.php?id=$1 rewriterule ^sitter/job-board/state/(.*)/page/(.*)/$ sitter/job-board.ph...
Read more