How to Average every certain # of columns
Requirement:
The user needs help with easier way to average data every 7th day of the week and from column header named "E" in the attached sample spreadsheet.
The user only shows dates from Jan 1 -7th on the spreadsheet below, but spreadsheet will be for full calendar year, and formula will be in "data transfer" tab in sample file.
Solution:
=IFERROR(AVERAGEIF(OFFSET(Sheet1!$B$2,0,(COLUMN(A2)-1)*42,1,42),"E",OFFSET(Sheet1!$B3,0,(COLUMN(A2)-1)*42,1,42)),0)
Obtained from the OzGrid Help Forum.
Solution provided by NBVC.
See also: Index to Excel VBA Code and Index to Excel Freebies and Lesson 1 - Excel Fundamentals and Index to how to… providing a range of solutions and Index to new resources and reference sheets
See also:
| How to first average a range and then round the value |
| How to average time between dates |
Click here to visit our Free 24/7 Excel/VBA Help Forum where there are thousands of posts you can get information from, or you can join the Forum and post your own questions.
Gallery
