| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
in excel, formula to work only when all cells full of data
I have a formula that includes averaging the contents of about 7 or 8 cells.
I don't want the formula to average until data is in all referenced cells. It wants to average as each cell value is entered. This is example of my formula: =(B3+ B4+B5+B6+B7+B8+B9+B10)/8 I am new to excel and I'm sure this is really simple. Thanks. |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
in excel, formula to work only when all cells full of data
One way:
=IF(COUNT(B3:B10)=8,AVERAGE(B3:B10),"") In article , "DINO" wrote: I have a formula that includes averaging the contents of about 7 or 8 cells. I don't want the formula to average until data is in all referenced cells. It wants to average as each cell value is entered. This is example of my formula: =(B3+ B4+B5+B6+B7+B8+B9+B10)/8 I am new to excel and I'm sure this is really simple. Thanks. |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
in excel, formula to work only when all cells full of data
thanks, that works. I appreciate the quick response.
"JE McGimpsey" wrote: One way: =IF(COUNT(B3:B10)=8,AVERAGE(B3:B10),"") In article , "DINO" wrote: I have a formula that includes averaging the contents of about 7 or 8 cells. I don't want the formula to average until data is in all referenced cells. It wants to average as each cell value is entered. This is example of my formula: =(B3+ B4+B5+B6+B7+B8+B9+B10)/8 I am new to excel and I'm sure this is really simple. Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I get excel to ignore formula in dependant cells... | Excel Worksheet Functions | |||
| Excel 2003, Convert EXISTING Worksheet Data to XML? | Excel Discussion (Misc queries) | |||
| trying to create an (almost) circular formula between cells and data validated cells with lists | Excel Worksheet Functions | |||
| Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) | |||
| stop excel from shifting cells up when a query returns no data | Excel Worksheet Functions | |||
Linear Mode
