+ Reply to Thread
Results 1 to 4 of 4

Need a formular that counts the number of meters drilled within different ranges

  1. 09-22-2012, 12:40 AM #1
    alex520
    alex520 is offline
    Registered User
    Join Date
    09-21-2012
    Location
    Perth, Austalia
    MS-Off Ver
    Excel 2010
    Posts
    10

    Need a formular that counts the number of meters drilled within different ranges

    dummy calc.xlsx

    Please can somebody help me?

    I need to create a formular that can display the difference between two numbers for a given range. Attached is a dummy spreadsheet.

    Thanks in advance for your help.

    Alex
    Last edited by alex520; 09-22-2012 at 07:10 AM.
    Reply With QuoteRegister To Reply
  2. 09-22-2012, 12:46 AM #2
    alex520
    alex520 is offline
    Registered User
    Join Date
    09-21-2012
    Location
    Perth, Austalia
    MS-Off Ver
    Excel 2010
    Posts
    10

    Re: Need a formular that counts the number of meters drilled within different ranges

    The green cells are what I already have, the red are the cells that I need to automatically populate.
    Reply With QuoteRegister To Reply
  3. 09-22-2012, 04:32 AM #3
    kvsrinivasamurthy
    kvsrinivasamurthy is offline
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    8,587

    Re: Need a formular that counts the number of meters drilled within different ranges

    Pl see the attached file.Formulas are in red region.
    Formulas can dragged horizontally and downwords.
    If it is Ok mark the thread SOLVED.

    Thanks.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  4. 09-22-2012, 07:12 AM #4
    alex520
    alex520 is offline
    Registered User
    Join Date
    09-21-2012
    Location
    Perth, Austalia
    MS-Off Ver
    Excel 2010
    Posts
    10

    Re: Need a formular that counts the number of meters drilled within different ranges

    Thank you very much.

    Alex
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1