Calculating Standard Deviation using IF and ignoring N/A values
Hello!
I'm having some trouble calculating the standard deviation while using conditional logic at the same time. I need to calculate the standard deviation of the values within a specific column (X:X) only IF another column (W:W) has a specific value (>1). At the same time, I want to ignore any N/A values in the range. If you can please give me some pointers, that would be wonderful. Thanks so much in advance!
Would something likeentered with CSE work?
Please Login or Register to view this content.
However, I recommend you change your column reference to an actual range...array formulas are labor intensive when referencing entire column ranges.
Spread the love, add to the Rep
"None of us are as smart as all of us."
Hm, I'm getting a #N/A return when I put that in..
Without sample data I cannot give more in depth help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks