Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
combining weekday formula, average and going back 7 cells
I am trying to get a weekly average from a temperature column. The excel
spreadsheet has a months worth of dates and an average for each day. I found the weekday formula and can convert weekdays to a number from 1 thru 7. From that I want to use the IF logic formula that day 7 it would average backwards 7 days (cells). There might be an easier way to do it but getting the syntax right is also a problem. Any help would be appreciated. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
combining weekday formula, average and going back 7 cells
Hi Craig,
Assuming your data is in column F: put this in G7 =AVERAGE(F1:F7) and drag down as far as is needed, the cell references will update automatically as you drag down. HTH Martin |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
a formula combining 2 cells into a % | Excel Discussion (Misc queries) | |||
WEEKDAY() function: display TEXT not numeric weekday | Excel Discussion (Misc queries) | |||
Need to bring back Average using either Sumproduct or CSE formula | Excel Discussion (Misc queries) | |||
average based on weekday | Excel Worksheet Functions | |||
Combining today +1 and weekday function | Excel Worksheet Functions |