# 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  Register To Reply

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"))  Register To Reply

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

Try

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

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

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

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

Thank you both, both solutions worked wonders.

Los  Register To Reply

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

You're welcome.  Register To Reply