+ Reply to Thread
Results 1 to 4 of 4

formula start and stop counting

  1. #1
    Registered User
    Join Date
    04-18-2016
    Location
    Stockholm Sweden
    MS-Off Ver
    2010
    Posts
    2

    formula start and stop counting

    section A B C D E F

    state 3 1 1 1 2 1

    lenght 10 10 10 10 10 10

    I have 6 sections (A-F) that will have a condition from 1-10.
    I want to start the calculation from the left and go to the right.
    I want to start the calculation when the state is not 1, and end it when it is not 1.
    For this example i will have two results. Section A will give the result 40m (A+B+C+D), and section E will give the result 20 m (E+F).
    So i can have 1 to 6 results depending on the state condition.
    The state condition could be modified, so 1 will become 0, and the rest of thestate numbers transformed to 1.

  2. #2
    Forum Expert José Augusto's Avatar
    Join Date
    10-29-2014
    Location
    Portugal
    MS-Off Ver
    2013-2016
    Posts
    3,329

    Re: formula start and stop counting

    Hi
    How do you do the calculation? Can you show us? Why A+B+C+D?
    What difference between state 2 and state 3 or other?
    In what way,the state condition could be modified?
    Please clarify your question.

  3. #3
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,062

    Re: formula start and stop counting

    I was wondering that too, however on reflection...

    "I want to start the calculation when the state is not 1, and end it when it is not 1"

    A is not 1, it's 3 so begin new calculation with A
    B C D are all 1 so add them too, so total is A+B+C+D
    However, E is not 1 so begin a new calculation with E
    F is not 1 so add that, so new total is E+F

    Obviously we are adding up the respective lengths rather than states
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

  4. #4
    Registered User
    Join Date
    04-18-2016
    Location
    Stockholm Sweden
    MS-Off Ver
    2010
    Posts
    2

    Re: formula start and stop counting

    I am building up a calculating on a electric grid.
    I have different sections in the grid, staring from the left. I have a table from where you chose the size for the fuse. Using a slide button for formula control.

    So a want to calculate the total lenght adding the sections until the next fuse appears. Because there are not necessarily fuses for every section. So if there are a fuse on only section A. I will adding all six sections.
    In the examble above, A fuse appears on section E. So Section B=C=D=F=!. Section lengtt for A=A+B+C+D and for E=E+F.

    There might be Areachanging for the cables, and depending on Area and Lenght and nominal current, you select fuses for Ik1 (electric terminology for chortcircuit)


    1 ------- " (=no fuse)"
    2 10 A
    3 16 A
    4 20 A
    5 25 A
    6 32 A
    7 40 A
    8 50 A
    9 63 A
    10 80 A
    11 100 A
    12 125 A
    13 160 A
    14 200 A
    15 250 A
    16 315 A

+ 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. Click Button to start/stop a Stop Watch
    By Aeneren in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-14-2016, 01:25 PM
  2. [SOLVED] Stop counting the blanks in formula
    By Biogeek1 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 12-05-2013, 02:48 PM
  3. Replies: 1
    Last Post: 08-21-2013, 02:14 PM
  4. Stop a counting formula
    By pattaz in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-09-2013, 06:06 AM
  5. need formula to start counting plus 450
    By mjcloward in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-12-2013, 04:26 PM
  6. Stop formula counting when it is equal to another cell?
    By Margate in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-08-2013, 08:04 PM
  7. Help - formula(s) for showing hours between start/stop (Novice user)
    By brianjluke in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 05-15-2013, 06:50 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