STDEV, IF, AND instead of STDEVIFS
Results 1 to 3 of 3

Thread: STDEV, IF, AND instead of STDEVIFS
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Jan 2018
    Location
    Kentucky
    Posts
    177
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default STDEV, IF, AND instead of STDEVIFS

    Based on the posts I've reviewed I'm not the only one looking for a STDEVIFS function in Excel.

    I'm trying to get along without it by using IF and AND. There are two criteria that need to be matched and if they match I want the STDEV. I am trying to get Excel to calculate STDEV for a specified flavour for each person. I've tried nesting AND inside an IF function but got a !VALUE error [ =STDEV(IF(AND($O$3:$O$1000=G14,$N$3:$N$1000=F14),$P$3:$P$1000,"")) ] I used Ctrl+Shift+Enter but it still didn't work. Can any of you assist?

    Column F has the reference names for each grouping and column G has the Flavour sub-grouping. Here is a sample of the data I'm pulling from:

    Col N Col O Col P
    Name Flavour Grams
    BB Plain 13.3
    BB Caramel 14.1
    NA Plain 13.6
    NA PB 15.7
    CS PB 16.3
    CS Caramel 17.4

  2. #2
    Board Regular
    Join Date
    Oct 2009
    Location
    Midlands, UK
    Posts
    7,556
    Post Thanks / Like
    Mentioned
    18 Post(s)
    Tagged
    3 Thread(s)

    Default Re: STDEV, IF, AND instead of STDEVIFS

    Your problem is AND will not produce an array of results. Try a nested if maybe:

    =STDEV(IF($O$3:$O$1000=G14,IF($N$3:$N$1000=F14,$P$3:$P$1000)))

  3. #3
    Board Regular
    Join Date
    Jan 2018
    Location
    Kentucky
    Posts
    177
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: STDEV, IF, AND instead of STDEVIFS

    Yes! Thank you!

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •