• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. Y

    How do I average multiple columns (ignoring zeros and blank cells)?

    I am using Excel 2010. Cross posts: https://www.excelforum.com/excel-formulas-and-functions/1304646-how-do-i-average-multiple-columns-ignoring-zeros-and-blank-cells.html#post5270732 https://www.mrexcel.com/board/threads/how-do-i-average-multiple-columns-ignoring-zeros-and-blank-cells.1122644/...
  2. Y

    How do I average multiple columns (ignoring zeros and blank cells)?

    I am trying to average multiple columns (ignoring zeros and blank cells). I have tried the following formulas. Neither is working. Could someone share as to what I may be dong incorrectly? =iferrors(AVERAGEIF(E3:E18,J3:J18,">0"),0) =iferrors(AVERAGEIFs(E3:E18,J3:J18,">0"),0) Thank you in...
  3. Y

    I am trying to build a simple timer.

    From the instruction page (link below) when I try to enter =timer.button.label I am getting the following message: "Reference is not valid." I noticed on the author's worksheet that in that cell instead of =timer.button.label it is showing =$C$3. Can someone explain this step to me and what I...
  4. Y

    I am trying to build a simple timer.

    This should help I just hope I am smart enough to use the information. Thank you, yeto
  5. Y

    I am trying to build a simple timer.

    After looking at some YouTube videos I realized I needed to be in design mode. This is what I have so far. Can this be changed so that the "stop" button will be red versus blue? Also, can the "duration" be seconds versus minutes? Sub startStopTimer() If Range("timer.button.label") = "Start"...
  6. Y

    I am trying to build a simple timer.

    I am working from this webpage: https://chandoo.org/wp/building-a-simple-timer-using-excel-vba-to-track-my-rubiks-cube-solving-speed-case-study/ This is what I have tried so far: step 1 = open excel spreadsheet (MS Office Pro 2010) step 2 = label column Time Stamp and Duration step 3 = I did...
Back
Top