+ Reply to Thread
Results 1 to 2 of 2

Make standard deviation of a sample IF data is within specific dates

  1. #1
    Registered User
    Join Date
    06-27-2019
    Location
    Isael
    MS-Off Ver
    2016
    Posts
    3

    Make standard deviation of a sample IF data is within specific dates

    Hi, I'm trying to create a formula that will make a standard deviation of all the data in the column IF the date in same row is between specific dates: B2 and C2.
    Iv'e used CTRL+SHIFT+ENTER for the formula to make it a range-formula
    It returns wrong value
    See file attachement
    {=STDEV.S(IF((נתונים[תאריך הבדיקה]>=טווח[תאריך התחלה])*(נתונים[תאריך הבדיקה]<=טווח[תאריך סיום]),B$6:B$34))}

    thank you.
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,535

    Re: Make standard deviation of a sample IF data is within specific dates

    See if the following array entered formula yields the expected result:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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] Standard Deviation malfunction when there is no data variation
    By greyhounddd in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-05-2019, 05:41 PM
  2. Standard deviation of a subset of the data
    By jfinnegan0 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-07-2018, 01:08 AM
  3. Calculating Returns and Standard Deviation from a data sample of share prices.
    By ofhani in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-15-2016, 11:51 AM
  4. [SOLVED] Populate Data set on Mean Standard Deviation and Correlation
    By sajeel in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-02-2014, 04:24 AM
  5. Data with fixed mean and standard deviation
    By Klorgrodan in forum Excel General
    Replies: 2
    Last Post: 02-10-2009, 10:23 AM
  6. Replies: 1
    Last Post: 01-21-2005, 01: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