I need some assistance coming up with a way to Average numbers in a list greater than a number in that list. The biggest hurdle I have is that the list cannot be sorted..... Example:
I want to Average the numbers in a list that are greater than the first number (so i want the average of all numbers in the list that are greater than .332 returned in B1 and all the numbers in the list greater than .378 returned in B2 (the catch is that these numbers are cell references (and have to be) so I cannot just averageif > .332 it would be averageif > A1 which I cannot get to work.... Any help would be appreciated....
A B
.332
.378
.359
.396
.395
.384
.380
.410
.345
.412
.416
.399
.419
.430
.465
.429
It sounds as though it's simply the syntax that's causing you the issue (re: AVERAGEIF)
B1: =AVERAGEIF(A:A,">"&A1) copied down
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
Thanks for help... Problem solved.... Issues was a little deeper (info i did not provide), but your help definately got me where I needed to be.....
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks