i have a list of numbers in one column and an answer (yes/no) in the next colomn
i want to check the standard deviation only if they answered yes
i know there isn't an stdevif function similar to averageif in excel 2007 but could anyone recommend a clever way in solving my problem?
thanks
Bookmarks