ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   slecting averages from a changing table (https://www.excelbanter.com/excel-programming/440898-slecting-averages-changing-table.html)

Seth.Schwarzkopf[_2_]

slecting averages from a changing table
 
i have a spread sheet set up to colect data on a daily basis from Jan 1 to
dec 31. i want to be able to have a month by month average of slect coloms
show up off to the side for quick access. colum a converts the date from
colum C in to the numerical value ( jan = 1 ect), Colum B show what week of
the year the date falls in to (jan 1 = week 1 of the year),colum C has the
dates in it, data is input in colums D to M. so i want to be able to take the
data in coulm H and M and be able to average everything that has a jan date
in to cell N4, feb in to cell N5 ect..can it be done?


All times are GMT +1. The time now is 12:55 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com