Counting blank cells that are empty buy contain a formula...

1. Counting blank cells that are empty buy contain a formula...

So i have my summer school attendance sheet that i need to calculate the % of students who have shown up for each program but i want the formula to update daily as i input the attendance. The problem i am running into is that the formula is counting the cells with a formula in them but with no number as a non blank.

This is the formula that i have been using =(SUM(C3:V3))/(B3*COUNTA(C3:V3))

I have attached a sheet with my data on one tab and my desired results on the other.

Any help would be greatly appreciated.

Los

2. Re: Counting blank cells that are empty buy contain a formula...

The problem is that the formulas are NOT returning ""
They're returning 0's.
But you have the cells custom formatted to Hide the 0's.

Try
=(SUM(C3:V3))/(B3*COUNTIF(C3:V3,"<>0"))

3. Re: Counting blank cells that are empty buy contain a formula...

Try

=(SUM(C3:V3))/(B3*COUNTIF(B14:V14,">0"))

4. Re: Counting blank cells that are empty buy contain a formula...

FYI,
Your numbers are incorrect because there are 17 numbers, not 18.

5. Re: Counting blank cells that are empty buy contain a formula...

Thank you both, both solutions worked wonders.

Los

6. Re: Counting blank cells that are empty buy contain a formula...

You're welcome.

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1