+ Reply to Thread
Results 1 to 6 of 6

Formula changes when pulling down along cells of a column

  1. #1
    Registered User
    Join Date
    06-30-2011
    Location
    New Delhi
    MS-Off Ver
    Excel 2003
    Posts
    46

    Formula changes when pulling down along cells of a column

    Well the wholw problem is explained in the comment section of the attached sheet...
    Attached Files Attached Files

  2. #2
    Forum Expert RobertMika's Avatar
    Join Date
    06-22-2009
    Location
    Haverhill, UK
    MS-Off Ver
    Excel 2003-13
    Posts
    1,530

    Re: Formula changes when pulling down along cells of a column

    =COUNTIFS($B$2:$B$25,">0",$B$2:$B$25,"<0.05")
    Add the dolar sigh to make your ranges absolute.
    If you are http://www.excelforum.com/image.php?type=sigpic&userid=125481&dateline=1392355029happy with the results, please add to the contributor's
    reputation by clicking the reputation icon (star icon).




    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved.
    To undo, select Thread Tools-> Mark thread as Unsolved.
    http://www.excelaris.co.uk

  3. #3
    Registered User
    Join Date
    06-30-2011
    Location
    New Delhi
    MS-Off Ver
    Excel 2003
    Posts
    46

    Re: Formula changes when pulling down along cells of a column

    hi , its working fine.....actually I forgot to add one more thing in the sheet.... i have attached the sheet again .....could u please have a look on the problem mentioned there....
    Attached Files Attached Files

  4. #4
    Forum Expert RobertMika's Avatar
    Join Date
    06-22-2009
    Location
    Haverhill, UK
    MS-Off Ver
    Excel 2003-13
    Posts
    1,530

    Re: Formula changes when pulling down along cells of a column

    like this
    =COUNTIFS($B$2:$B$25,">"&C2,$B$2:$B$25,"<"&C3)

  5. #5
    Registered User
    Join Date
    06-30-2011
    Location
    New Delhi
    MS-Off Ver
    Excel 2003
    Posts
    46

    Re: Formula changes when pulling down along cells of a column

    thanks alot its working fine...............

  6. #6
    Forum Expert RobertMika's Avatar
    Join Date
    06-22-2009
    Location
    Haverhill, UK
    MS-Off Ver
    Excel 2003-13
    Posts
    1,530

    Re: Formula changes when pulling down along cells of a column

    You are welcome.
    Please add reputation if you happy with the solution.

+ 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. Formula for pulling only cells with certain value
    By ghladik in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-10-2012, 12:21 PM
  2. Replies: 1
    Last Post: 10-01-2012, 12:29 PM
  3. formula pulling first name and middle name in same column
    By johnmerlino in forum Excel General
    Replies: 7
    Last Post: 11-03-2010, 11:38 AM
  4. [SOLVED] Pulling Row and Column labels from other cells.
    By MTUSNOW in forum Excel General
    Replies: 0
    Last Post: 09-07-2005, 07:05 PM
  5. Excel formula needed to amounts into one column pulling from 2 col
    By Scott in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-03-2005, 03: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