Results 1 to 5 of 5

STDEVIFS: Just like AVERAGEIFS, How?

Threaded View

  1. #1
    Registered User
    Join Date
    05-15-2020
    Location
    Amsterdam, NL
    MS-Off Ver
    2010
    Posts
    3

    STDEVIFS: Just like AVERAGEIFS, How?

    The code below gives me the average value of a data comlumn (ZENIT!H:H), using a specific range (K2 & K3) of another data column (ZENIT!N:N). So what it does: It averages all ZENIT!H:H values that fall between my K2 & K3 interval, those values refer to ZENIT!N:N.

    =AVERAGEIFS(ZENIT!H:H,ZENIT!N:N,"<="&K2,ZENIT!N:N,">"&K3)

    Now i want to get the standard deviations of the specific ranges instead of the averages, what formula can I use.

    Thanks for the help!
    Last edited by cabisterb; 05-15-2020 at 06:07 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Averageifs help
    By parbynat in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-01-2018, 05:50 AM
  2. [SOLVED] Trouble producing STDEVIFS array
    By phbryan in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-28-2018, 12:54 PM
  3. [SOLVED] Averageifs
    By kent97 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-22-2017, 02:40 AM
  4. AVERAGEIFS can you use it with an or.
    By Vokey9 in forum Excel Formulas & Functions
    Replies: 21
    Last Post: 02-26-2016, 05:05 PM
  5. [SOLVED] Averageifs
    By nd4spd in forum Excel General
    Replies: 7
    Last Post: 07-04-2014, 05:33 AM
  6. [SOLVED] Averageifs?
    By thelastflame in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 03-10-2014, 01:09 PM
  7. [SOLVED] Stdevifs ??
    By BPG in forum Excel General
    Replies: 2
    Last Post: 04-21-2012, 06:19 AM

Tags for this Thread

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