The code below gives me the average value of a data comlumn (ZENIT!H:H), using a specific range (K2 & K3) of another data column (ZENIT!N:N). So what it does: It averages all ZENIT!H:H values that fall between my K2 & K3 interval, those values refer to ZENIT!N:N.
=AVERAGEIFS(ZENIT!H:H,ZENIT!N:N,"<="&K2,ZENIT!N:N,">"&K3)
Now i want to get the standard deviations of the specific ranges instead of the averages, what formula can I use.
Thanks for the help!
Last edited by cabisterb; 05-15-2020 at 06:07 AM.
you would need to use an Array -- at which point you should avoid using entire column references
Formula:
Please Login or Register to view this content.
Hey, thanks for replying. The formula you gave returns the same value as the one I used:Formula:Please Login or Register to view this content.
The problem I have with that formula that is: no matter what range or different range interval I enter (K2 & K3), it returns the exact same value. My expectation is that, just like the averages; the values differ since the ZENIT H column is not correlated to the ZENIT N column.
oh dear, sorry, not sure what I did there... should have read:
in the above, H will only be included in the calc where corresponding values in N pass the K2/K3 criteriaFormula:Please Login or Register to view this content.
Thank man, works perfectly. When I thought all hope was lost :P
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks