Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
leave cell blank and continue with formula
#Animals Total Pounds 1062 70.90 75,300 1063 69.36 73,734 1063 71.08 75,556 1066 68.89 73,439 1064 69.27 73,704 1069 70.29 75,143 1073 70.83 75,997 1075 70.59 75,881 1081 67.82 73,316 1083 69.69 75,474 1068 71.64 76,516 0 ????? 0 ????? 22353 #DIV/0! 1,352,243 721.1 #DIV/0! 75124.61111 Each day, I add the numbers of animals and lbs in the spreadsheet. Is it possible to get the bottom to average even when all cells are not filled in? When I get to the end of the month the 31st and 30th might not have data depending on the month, so I am looking to skip those cells when no data is entered. Any help? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
leave cell blank and continue with formula
If you use
=AVERAGE(B2:B32) and =AVERAGE(C2:C32) blanks will be ignored. In article , hlpme wrote: #Animals Total Pounds 1062 70.90 75,300 1063 69.36 73,734 1063 71.08 75,556 1066 68.89 73,439 1064 69.27 73,704 1069 70.29 75,143 1073 70.83 75,997 1075 70.59 75,881 1081 67.82 73,316 1083 69.69 75,474 1068 71.64 76,516 0 ????? 0 ????? 22353 #DIV/0! 1,352,243 721.1 #DIV/0! 75124.61111 Each day, I add the numbers of animals and lbs in the spreadsheet. Is it possible to get the bottom to average even when all cells are not filled in? When I get to the end of the month the 31st and 30th might not have data depending on the month, so I am looking to skip those cells when no data is entered. Any help? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
leave cell blank and continue with formula
If you want to ignore zeros....
(AVERAGE(IF(C2:C32<0,C2:C32,""))) "hlpme" wrote in message ... #Animals Total Pounds 1062 70.90 75,300 1063 69.36 73,734 1063 71.08 75,556 1066 68.89 73,439 1064 69.27 73,704 1069 70.29 75,143 1073 70.83 75,997 1075 70.59 75,881 1081 67.82 73,316 1083 69.69 75,474 1068 71.64 76,516 0 ????? 0 ????? 22353 #DIV/0! 1,352,243 721.1 #DIV/0! 75124.61111 Each day, I add the numbers of animals and lbs in the spreadsheet. Is it possible to get the bottom to average even when all cells are not filled in? When I get to the end of the month the 31st and 30th might not have data depending on the month, so I am looking to skip those cells when no data is entered. Any help? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
leave cell blank and continue with formula
Press CTRL+SHIFT+ENTER. not just ENTER and this formula requires all the
cells to be filled. If you have no data, enter a 0 in that cell. "Gaurav" wrote in message ... If you want to ignore zeros.... (AVERAGE(IF(C2:C32<0,C2:C32,""))) "hlpme" wrote in message ... #Animals Total Pounds 1062 70.90 75,300 1063 69.36 73,734 1063 71.08 75,556 1066 68.89 73,439 1064 69.27 73,704 1069 70.29 75,143 1073 70.83 75,997 1075 70.59 75,881 1081 67.82 73,316 1083 69.69 75,474 1068 71.64 76,516 0 ????? 0 ????? 22353 #DIV/0! 1,352,243 721.1 #DIV/0! 75124.61111 Each day, I add the numbers of animals and lbs in the spreadsheet. Is it possible to get the bottom to average even when all cells are not filled in? When I get to the end of the month the 31st and 30th might not have data depending on the month, so I am looking to skip those cells when no data is entered. Any help? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
leave cell blank and continue with formula
Well...I just tried and it works even if you leave some cells blank. Dont
forget to array enter it...CTRL+SHIFT+ENTER. "Gaurav" wrote in message ... If you want to ignore zeros.... (AVERAGE(IF(C2:C32<0,C2:C32,""))) "hlpme" wrote in message ... #Animals Total Pounds 1062 70.90 75,300 1063 69.36 73,734 1063 71.08 75,556 1066 68.89 73,439 1064 69.27 73,704 1069 70.29 75,143 1073 70.83 75,997 1075 70.59 75,881 1081 67.82 73,316 1083 69.69 75,474 1068 71.64 76,516 0 ????? 0 ????? 22353 #DIV/0! 1,352,243 721.1 #DIV/0! 75124.61111 Each day, I add the numbers of animals and lbs in the spreadsheet. Is it possible to get the bottom to average even when all cells are not filled in? When I get to the end of the month the 31st and 30th might not have data depending on the month, so I am looking to skip those cells when no data is entered. Any help? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to leave a formula cell blank when it has no calculation to make | Excel Discussion (Misc queries) | |||
Formula <0 leave cell blank | Excel Discussion (Misc queries) | |||
How do I leave formula cell blank if 2nd reference cell is empty? | Excel Discussion (Misc queries) | |||
leave a cell blank | Excel Worksheet Functions | |||
leave cell blank | Excel Discussion (Misc queries) |