Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]() #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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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) |