Hi All!
As shown in attachement, I used averageifs(XXX) to get a specific averge, and I would like to have a standard deviation that corresponds to the average value. What function would I need to use?
Thanks!!!
Hi All!
As shown in attachement, I used averageifs(XXX) to get a specific averge, and I would like to have a standard deviation that corresponds to the average value. What function would I need to use?
Thanks!!!
Try this:
=STDEV(IF((A2:A10>E2)*(A2:A10<D2),A2:A10))
This is an array function and must be entered with Ctrl-Shift-Enter, not just Enter.
Works great! Thank you very much!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks