If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Match then lookup | Tenacity | Worksheet Functions | 10 | December 3rd, 2005 05:30 AM |
Excel 2003, Convert EXISTING Worksheet Data to XML? | [email protected] | General Discussion | 4 | November 16th, 2005 04:45 AM |
Can we import an Excel sheet to use as base for report? | StargateFan | New Users | 9 | November 4th, 2005 07:32 PM |
trying to create an (almost) circular formula between cells and data validated cells with lists | KR | Worksheet Functions | 0 | May 12th, 2005 07:21 PM |
Excel Worksheets | Richard | General Discussion | 2 | July 8th, 2004 04:34 AM |