Excel averaging cell range

[Closed]
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,
I'm working in Excel 2007 and I need to calculate the average value of cells in column D whose values in column C are within a specific threhold. Right now, I enter =average(d2:d?) and visually scan column C to determine which row to end with (cells in column C whose value is less than 1). I then move to the next empty column and enter =average(d?:d??) looking at column C to now find the rows having values greater than 1 but less than 2. I repeat this several times until I have an average of column D data when column C values are greater than 5 and less than 6.

How can I automate this process? I have over 30,000 files that I need to process!

Thanks.


1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
Could you please upload a sample EXCEL file WITH sample data, macro, formula , conditional formatting etc on some shared site like https://authentification.site , http://docs.google.com, http://wikisend.com/ , http://www.editgrid.com etc
A N D post back here the link to allow better understanding of how it is now and how you foresee. Based on the sample book, could you re-explain your problem too