Thanks DonkeyOte for your help on the last one...
Two more (more complicated) outputs that I need.
I need the AVERAGE and STDEVof values in $C$1:$C$2793 that fit the criteria of having "a1" in $a$1:$a$2793 and where $c$1:$c$2793 is >50.
Thanks DonkeyOte for your help on the last one...
Two more (more complicated) outputs that I need.
I need the AVERAGE and STDEVof values in $C$1:$C$2793 that fit the criteria of having "a1" in $a$1:$a$2793 and where $c$1:$c$2793 is >50.
Again if using XL2007, you can use AVERAGEIFS for the first
For the STDEV you will need to use an ArrayPlease Login or Register to view this content.
Please Login or Register to view this content.
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