Forum Discussion

Erika Smith's avatar
Erika Smith
Copper Contributor
Jan 10, 2017
Solved

Formula help please

I am trying to write a formula that adds time together or an employee sheet, but I would like it to reset whenever a "0" is input. For Example: Adding Monday through Friday, each employee working 10 ...
Formulas & Functions
Need Help
  • Wyn Hopkins's avatar
    Wyn Hopkins
    Jan 10, 2017

    Hi Erika

     

    That's a tricky one.  I've attached a file for you to look at.

     

    I've split it into 2 formulas

     

    The first formula finds where in the row of numbers the first 0 appears

     

    The second formula then adds up the numbers from that point

     

Wyn Hopkins's avatar
Wyn Hopkins
MVP
Jan 10, 2017

Hi Erika

 

That's a tricky one.  I've attached a file for you to look at.

 

I've split it into 2 formulas

 

The first formula finds where in the row of numbers the first 0 appears

 

The second formula then adds up the numbers from that point

 

  • Erika Smith's avatar
    Erika Smith
    Copper Contributor
    Jan 11, 2017
    Nevermind! I figured out a way that it works with those exact formulas! THANK YOU SO MUCH! You saved me from utter craziness.
  • Erika Smith's avatar
    Erika Smith
    Copper Contributor
    Jan 11, 2017

    I wrote the formulas just as you showed and at first it worked when I only had one zero within the week... is there any way that it can be written to provide the answer if there are multiple zeros within the week? Attached is the worksheet I have been attempting to put the formula on...

    • Wyn Hopkins's avatar
      Wyn Hopkins
      MVP
      Jan 11, 2017

      I've added a couple of formula options you could use to replace the original MATCH formula

       

      They both need you to add a row at the top to "lookup" the starting point

       

Resources