+ Reply to Thread
Results 1 to 2 of 2

Formula DB.DEV.ST for calculate the deviation standard with criteria

  1. #1
    Registered User
    Join Date
    06-22-2018
    Location
    Stabio
    MS-Off Ver
    2007
    Posts
    1

    Smile Formula DB.DEV.ST for calculate the deviation standard with criteria

    Hello,

    with formula "DB.DEV.ST" i want to calculate the deviation standard on a database.

    In the first summary sheet i have entered the names of all the teams, while in the second sheet i have created a database with the data of all the matches.

    In the first tab next to the name of each team i would like to calculate the standard deviation for each team. In order to do this I tried the formula "DB.DEV.ST" which should allow to calculate the standard deviation using criteria. I tried but it returns me the error "#VALUE". I can not figure out where the problem is...

    I hope i explained, attached the file i have created.

    Can someone help me ? Thanks to anyone in advance
    Attached Files Attached Files

  2. #2
    Forum Expert sandy666's Avatar
    Join Date
    02-05-2015
    Location
    Any Country
    MS-Off Ver
    farerwell
    Posts
    8,749

    Cool Re: Formula DB.DEV.ST for calculate the deviation standard with criteria

    maybe this one
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    but B1 on Squadre tab should be: Squadra casa

    DSTDEV function
    Last edited by sandy666; 06-22-2018 at 06:06 AM. Reason: link added
    sandy
    How to create an editor for Power Query with Notepad++ (tutorial)
    How to create timeline project with vertical today marker (2010, 2013, 2016 etc...) (examples)
    Tips for Excellent Spreadsheets

    What makes learning so hard is the amount of knowledge you have to unlearn
    Why is my program not doing what I expect?
    Because you set the wrong expectations. Rewire your brain

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Formula needed to calculate and auto-update Standard Deviation
    By Onditi in forum Excel Formulas & Functions
    Replies: 22
    Last Post: 10-08-2017, 02:36 PM
  2. help to calculate standard deviation
    By lana86 in forum Excel Programming / VBA / Macros
    Replies: 21
    Last Post: 03-12-2015, 10:27 PM
  3. [SOLVED] VBA to calculate Standard Deviation
    By schmidtkicker in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-11-2014, 06:17 AM
  4. Calculate Standard Deviation
    By goss in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-05-2013, 05:11 AM
  5. Need a more efficient way to calculate Standard Deviation
    By StevenAlberta in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 07-24-2012, 03:17 PM
  6. Calculate one standard deviation from mean
    By missyreiber in forum Excel General
    Replies: 3
    Last Post: 09-08-2010, 11:40 AM
  7. How to calculate 2 standard deviation?
    By Li in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-12-2005, 05:06 PM

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