+ Reply to Thread
Results 1 to 2 of 2

0's keep restarting my total count

  1. #1
    Registered User
    Join Date
    06-15-2015
    Location
    WV
    MS-Off Ver
    2013
    Posts
    17

    0's keep restarting my total count

    Please Login or Register  to view this content.
    =IF(B38 = 0, 0,C37+B38) =D37+$F$5
    Need help fine turning this code so that when I enter a 0 it doesn't restart my actual and goal MTD count.
    Sand Tracking SharePoint - Q2 2015.xlsx
    Last edited by tejasjeorge; 06-30-2015 at 10:12 AM.

  2. #2
    Valued Forum Contributor
    Join Date
    02-09-2006
    Location
    Melbourne, Australia
    MS-Off Ver
    Office 2016
    Posts
    1,075

    Re: 0's keep restarting my total count

    Your workbook is protected so it is impossible to add rows matching TODAY() to test the formula. Could you attach an unprotected copy please?
    Trish in Oz
    -------------
    A problem well defined is a puzzle half solved


    If you attach a sample of your workbook it will be easier to find a solution. Remember to remove/replace sensitive data before uploading the file. Look here if you need help with attachments:
    http://www.excelforum.com/faq.php?fa...b3_attachments

+ 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. Restarting a count
    By Journeyman3000 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-19-2013, 08:07 PM
  2. [SOLVED] count occupied cells, but put count total in different worksheet
    By NewbieOfVBA in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-24-2012, 07:30 PM
  3. Restarting a private sub
    By Josiah in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-26-2012, 09:13 AM
  4. [SOLVED] Restarting a macro
    By BR in forum Excel Formulas & Functions
    Replies: 19
    Last Post: 12-23-2005, 06:00 PM
  5. How do i count numbers and letters to find a total count of all
    By Linda in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-10-2005, 12:55 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