Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
adding accross sheets in a workbook
Hi,
I am adding accross sheets in a workbook with SUM('Start!:End!'!G51) and need a way to calculate the average of the result. The number of sheets change and not always will the cells have data. Sometimes they will be blank and sometimes they contain zero's. I can't figure out how to count how many of the sheets have numbers larger than zero to divide with. something like SUM('Start!:End!'!G51)/(COUNTA('Start!:End!'!g51) except able to know how many cells are blank or contain zero's. Any ideas? Todd |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sum, several different sheets in the same workbook | Excel Worksheet Functions | |||
added line won't update accross sheets | Excel Discussion (Misc queries) | |||
Want to link several sheets in single workbook for searching purposes. | Excel Discussion (Misc queries) | |||
In Excel, how do I print the workbook sheets to 2sided paper? | Excel Discussion (Misc queries) | |||
How can I delete similar rows in excel workbook with many sheets? | Excel Worksheet Functions |