Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
count cells, then reset count when value in another cell changes | Excel Worksheet Functions | |||
How do i count Text in the Cells, but not formulas. | Excel Discussion (Misc queries) | |||
Count if criteria extracts from 2 cells both with formulas | Excel Discussion (Misc queries) | |||
CELLS NOT CALC FORMULAS - VALUES STAY SME FORMULAS CORRECT?? HELP | Excel Worksheet Functions | |||
count formulas | Excel Discussion (Misc queries) |