Just like sumif and averageif, is there a standarddeivationif?
Just like sumif and averageif, is there a standarddeivationif?
Be who you are and say what you feel, because those who mind don't matter and those who matter don't mind.
hi there,
there isn't, but you can enter it as an array formula with an IF condition embedded, for e.g.,
=stdev(if(a1:a10="x",b1:b10))
see signature about array entry.
Last edited by icestationzbra; 03-24-2014 at 12:49 AM.
- i.s.z -
CSE, aka Array aka { }, formulae are confirmed with CONTROL+SHIFT+ENTER.
Replace commas ( , ) with semicolons ( ; ) in formulae, if your locale setting demands.
All good ideas are courtesy resources from this forum as well as others around the web.
- e.o.m -
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks