| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Average range of discontinuous cells
I have a block of columns (P-CT) that I need to average but only every 4th
one. Example: I need to average P, T, X, AB, AF, AJ, AN, AR, AV, AZ, BD, BH, BL, BP, BT, BX, CB, CF, CJ, CN, CR. If I just type =AVERAGE(selecting these cells) it gives me 40238 when the only one with a value is cell P. These cells contain dates if anything. They are payment dates. I need the average number of dates it took to pay something. Any ideas for Excel 2003? Thanks. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Average range of discontinuous cells
Never mind. I forgot to include my beginning date. It works. Just user
error. "Nadine" wrote: I have a block of columns (P-CT) that I need to average but only every 4th one. Example: I need to average P, T, X, AB, AF, AJ, AN, AR, AV, AZ, BD, BH, BL, BP, BT, BX, CB, CF, CJ, CN, CR. If I just type =AVERAGE(selecting these cells) it gives me 40238 when the only one with a value is cell P. These cells contain dates if anything. They are payment dates. I need the average number of dates it took to pay something. Any ideas for Excel 2003? Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| average range of cells with zero and blanks | Excel Discussion (Misc queries) | |||
| sum value of nonblank discontinuous cells | New Users to Excel | |||
| SumIf with discontinuous cells? | Excel Discussion (Misc queries) | |||
| Allow pasting as a value to several discontinuous cells at once. | Excel Discussion (Misc queries) | |||
| Can an array be made of discontinuous cells of the same row? | Excel Discussion (Misc queries) | |||
Hybrid Mode
