Hello,
I'm sure this is a very easy problem to fix but why isnt my averageif formula working?!
=AVERAGEIF(Sheet2!A:A,"<=A3&>A4",Sheet2!D:D)
Thanks,
Rich
Hello,
I'm sure this is a very easy problem to fix but why isnt my averageif formula working?!
=AVERAGEIF(Sheet2!A:A,"<=A3&>A4",Sheet2!D:D)
Thanks,
Rich
You would use AVERAGEIFS and you would have two separate tests namely: "<="&A3 and ">"&A4
=AVERAGEIFS(Sheet2!D:D,Sheet2!A:A,"<="&A3,Sheet2!A:A,">"&A4)
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks