How do I not count cells that have formulas in them
 

I want to find the average of steel tires in (B9) that I have a day, but
only the days we did production. We did production only 4 days that week out
of 6 days of production. The answer should be 25 but it always divides by 6
as there are formulas in coloum D, which is adding B & C together
the formula i wrote...in B9 was B8/count(D2:D7)


A B C D
1 Steel Solid # of Tires
2 2/22/2010 90 10 100
3 2/23/2010
4 2/24/2010 10 10
5 2/25/2010 100 100
6 2/26/2010 60 60
7 2/27/2010
8 Total 100 170 270
9 AVG 17 34 45

How do I not count cells that have formulas in them
 

use =B8/COUNTIF(D2:D7,"0") in B9 you will return 25

as it count only 0 in the range from d2 to d7.

"Rubber 4 u" wrote:


I want to find the average of steel tires in (B9) that I have a day, but
only the days we did production. We did production only 4 days that week out
of 6 days of production. The answer should be 25 but it always divides by 6
as there are formulas in coloum D, which is adding B & C together
the formula i wrote...in B9 was B8/count(D2:D7)


A B C D
1 Steel Solid # of Tires
2 2/22/2010 90 10 100
3 2/23/2010
4 2/24/2010 10 10
5 2/25/2010 100 100
6 2/26/2010 60 60
7 2/27/2010
8 Total 100 170 270
9 AVG 17 34 45

How do I not count cells that have formulas in them
 

use =B8/COUNTIF(D2:D7,"0") in B9 you will return 25

as it count only 0 in the range from d2 to d7.

"Rubber 4 u" wrote:


I want to find the average of steel tires in (B9) that I have a day, but
only the days we did production. We did production only 4 days that week out
of 6 days of production. The answer should be 25 but it always divides by 6
as there are formulas in coloum D, which is adding B & C together
the formula i wrote...in B9 was B8/count(D2:D7)


A B C D
1 Steel Solid # of Tires
2 2/22/2010 90 10 100
3 2/23/2010
4 2/24/2010 10 10
5 2/25/2010 100 100
6 2/26/2010 60 60
7 2/27/2010
8 Total 100 170 270
9 AVG 17 34 45