+ Reply to Thread
Results 1 to 3 of 3

Formla needed for Var-If Function

  1. #1
    Registered User
    Join Date
    11-27-2013
    Location
    California, United States
    MS-Off Ver
    Excel 2007
    Posts
    2

    Lightbulb Formla needed for Var-If Function

    Hi,

    I used AverageIf for my data, I am looking for a function that works like AVERAGEIF but instead of average, calculating Variance.
    Here is how I use it :
    =AVERAGEIF(Table1[Shift],"1st",Table1[Time])
    If the shift column is "1st" then calculate the average of time.
    I've attached the sample of my excel file.

    Thank you in advance for helping me.
    Attached Files Attached Files

  2. #2
    Forum Expert daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,675

    Re: Formla needed for Var-If Function

    The formula you have in the worksheet is the right one, i.e.

    =VAR(IF(Table1[Shift]="1st",Table1[Time]))

    ...but this is an "array formula"

    Select the cell, press F2 to select formula and then hold down CTRL and SHIFT keys and press ENTER. If done correctly you will see curly braces around the formula like { and } and you should get the correct result
    Audere est facere

  3. #3
    Registered User
    Join Date
    11-27-2013
    Location
    California, United States
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Formla needed for Var-If Function

    Thank you so much

+ 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. Using inputted information to be used in a formla
    By gdrobertson in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-29-2013, 12:11 PM
  2. [SOLVED] Need a formla for if 0.00 return a blank or sum a range
    By SueMac in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-20-2012, 02:31 PM
  3. which formla need to use
    By anwitha in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-28-2011, 09:19 AM
  4. [SOLVED] Excel formla
    By Forgetfulpgk in forum Excel General
    Replies: 5
    Last Post: 08-22-2006, 01:10 PM
  5. [SOLVED] How can I create a formla using date ranges
    By Digital2k in forum Excel General
    Replies: 17
    Last Post: 06-30-2006, 10:30 PM

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