Previous Topic Next Topic

Excel averaging cell range

Closed
cj - Aug 8, 2010 at 12:48 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Aug 9, 2010 at 02:23 PM
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.


Related:

1 response

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Aug 9, 2010 at 02:23 PM
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

Similar discussions

How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
Highlight cell if another cell contains specific text
Abbi -
vcoolio -

1 response
Excel if range of cell contain a text put a cell value in
diegomagum -
TrowaD -

11 responses
Date formatting in dd/mm/yyyy
nisha -
appu -

11 responses