+ Reply to Thread
Results 1 to 2 of 2

Calculating StdDev combined w/ If function

  1. #1
    Forum Contributor
    Join Date
    07-01-2005
    Posts
    103

    Calculating StdDev combined w/ If function

    I have a list of names in column A, with corresponding numbers in column B

    There are many different names in A that repeat over and over.
    I would like to calculate the StDev for the column B values for each unique name.

    This is what I'm trying to create: StdevIF(A="JimBob",B:B)

    I don't think there is a way to do this with the Stdev function, but one can calculate the standard deviation manually in the cell. This is what I've come up with, where C3 = "JimBob"
    =SQRT(SUMPRODUCT(--(A$2:A$1048576=C3),(B$2:B$1048576)-AVERAGEIF(A$2:A$1048576,C3,B$2:B$1048576)^2)/COUNTIF(A$2:A$1048576,C3))

    but it is not returning the same value as STDEV does when I isolate JimBob's numbers and use the STDev function. I don't know if this is because I'm manually calculating the SD wrong, or I've made a mistake in my syntax. Any help would be greatly appreciated.
    -Paul

  2. #2
    Forum Contributor
    Join Date
    07-01-2005
    Posts
    103
    You can do this like so...

    =STDEV(IF(A:A=C3,B:B))

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1