+ Reply to Thread
Results 1 to 3 of 3

Formula link break for Countif and Averageif statements

  1. #1
    Registered User
    Join Date
    04-21-2013
    Location
    Charlotte, NC
    MS-Off Ver
    Excel 2007
    Posts
    27

    Formula link break for Countif and Averageif statements

    Per attachment, I have simple Countif and Averageif formulas that I would like to have linked to variable data in cell E6 on the Assumptions (2) tab however, the formula is not taking the cell as the criteria and only taking a hard number when I am using >=. Can anyone help?

    The example would be: I3 needs to be able to use the data changed in E6 for the >= number instead of the hardkey 29...

    Thank you.


    Josh
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    05-17-2013
    Location
    Canada
    MS-Off Ver
    Excel 2010
    Posts
    49

    Re: Formula link break for Countif and Averageif statements

    Change Cell D6 to >=
    Change Cell E6 to <=
    Change Cell I3 to =Countif('All FHA HSS Pipes'!K4:K20000, $F$6)
    Drag to copy I3 to extend your formula

    HTH

  3. #3
    Registered User
    Join Date
    04-21-2013
    Location
    Charlotte, NC
    MS-Off Ver
    Excel 2007
    Posts
    27

    Re: Formula link break for Countif and Averageif statements

    Perfect, thank you!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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