Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Queation about monthly and weekly averages
I have annual data for concentrations of various species for last
couple of years. I want to find out monthly (12 values) as well as weekly averages(52 values) for these years. I did it manually for one year, but its taking lot of time. Can it be done using single formula and then copying it down the column to get these values? Please help me. Thanks, Omkar |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Template to track weekly & monthly totals, by day & date? | Excel Discussion (Misc queries) | |||
Collecting weekly and monthly totals from daily data | Excel Worksheet Functions | |||
Function for generating monthly & weekly averages | Excel Worksheet Functions | |||
Weekly and Monthly Subtotals | Excel Discussion (Misc queries) | |||
Converting Weekly Data into Monthly Averages | Excel Discussion (Misc queries) |