| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
AVERAGEing non contiguous rows
Hi,
I have a spreadsheet where the rows are labelled in a repeating sequence Mon, Tue, Wed, Thu, Fri - the first row (Mon) is 118 and the last row (Fri) is 1007. There are then a number of columns (C thru T) with numeric values relating to each respective weekday. I want an expression that will allow me to average the non zero entries for each weekday. Having read other posts, I tried =AVERAGE(IF(MOD(ROW(C$118:C$1007),5)=0,IF(C$118:C$ 10070,C$118:C$1007))) but the results don't look right - can anyone spot where I'm going wrong? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to automatically delete non-contiguous rows | Excel Discussion (Misc queries) | |||
| Macro to repeat 2 contiguous rows to top of each page | Excel Discussion (Misc queries) | |||
| Selecting a group of contiguous rows | Excel Discussion (Misc queries) | |||
| total column amounts from non-contiguous rows | Excel Discussion (Misc queries) | |||
| Averageing Costs | Excel Discussion (Misc queries) | |||
Threaded Mode
