Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Summing cells in Excel
I have 8 different worksheets with number data. I would like to get the average of the *non-zero* values of each cell across the eight workbooks. The Average fn counts zero as well, so I tried using Sumif/Countif. Problem is that these fns work with cell ranges and not with individual cells from different workbooks. Any ideas how to do it? -- marilena ------------------------------------------------------------------------ marilena's Profile: http://www.excelforum.com/member.php...o&userid=16164 View this thread: http://www.excelforum.com/showthread...hreadid=275948 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
How do I merge cells in Excel, like just 2 cells to make one big . | Excel Discussion (Misc queries) | |||
Adding contents of cells by clicking in Excel 2002 | Excel Discussion (Misc queries) | |||
linking cells in Excel 2003. How to not truncate to 255 characters. | Excel Discussion (Misc queries) | |||
Excel 2003 isn't updating my cells | Excel Worksheet Functions |