Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cross-Worksheet Averaging
Hi all, I have searched on here and tried to find a solution my problem. I will do my best to explain it. To start off, the problem exists with DIV/0 errors. Not sure if I fix those errors it maybe easier to work w/ however that is alot of fixing of the current formulas. Here we go: I want to average out the Bias on many sheets in several workbooks. What I did was put the bias in one cell in wrkbook1, tab1 (a1 of wrkbk1 in tab1). Sounds crazy I know. I want to take the average of cell a1 in each worksheet of each workbook (30 sheets in 12 workbooks). For example, In workbook July2006 / tab 1 (which means the first) through to 31 (which means the 31st). I want to average all the cell a1's in workbook July2006. However, the days that have no data entered gives the error "DIV/0" which causes the formula I was trying to use to not work. What I want is to average out the cell a1 if it is a number from tabs 1-31. But now, the average is in a new workbook...not the July2006 file but another file named Total.xls I hope you understand this...if not, let me know and I'll try to clarify. Thanks in advance. Jason -- drvortex ------------------------------------------------------------------------ drvortex's Profile: http://www.excelforum.com/member.php...o&userid=15896 View this thread: http://www.excelforum.com/showthread...hreadid=556682 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Worksheet not showing up in VBE | Excel Worksheet Functions | |||
Protect Workbook vs Worksheet?? | Excel Worksheet Functions | |||
Inserting Filtered RC cell information into other worksheets | Excel Discussion (Misc queries) | |||
Search/Match between 2 x separate Worksheets and populate result in third worksheet | Excel Discussion (Misc queries) | |||
Weekly Transaction Processing | Excel Worksheet Functions |