+ Reply to Thread
Results 1 to 3 of 3

Running totals?

  1. #1
    Registered User
    Join Date
    07-25-2012
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    48

    Running totals?

    I'm trying to get a formula to calculate based on a cell being populated for a monthly tracking sheet.

    My example:
    Column A has dates- 1-Jun thru 5-Jun in cells A1:A5

    Column B has order quantities

    Column C has revenue totals

    I want my formula to calculate my revenue per day, but only when cells in column B are entered- that way the formula stays up to date. Right now I have to take the sum of revenue in column C and divide by the number of days in the week or month to get my number. I have to update that day number each day- hence why I'd like it to calculate once data is entered in column B.

    I hope all of this makes sense... thanks in advance!

  2. #2
    Forum Contributor
    Join Date
    07-25-2012
    Location
    Winterville, NC
    MS-Off Ver
    Excel 2013
    Posts
    141

    Re: Running totals?

    You could use AVERAGE(C1:C5) instead of SUM(C1:C5). Or you could do SUM(C1:C30)/COUNTA(C1:C30)...but if C6-C30 are blank, it would only divide by 5. Does that help? Hard to tell without seeing it.


    If this post was helpful or at least brought a smile to your face , please click the Add Reputation button as a way to say thank you!!!!!!

  3. #3
    Registered User
    Join Date
    07-25-2012
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    48

    Re: Running totals?

    The counta function was what I needed- thanks!

+ 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. [SOLVED] running totals in Pivot Table - removing a user from the totals for the current week
    By eisenbergg in forum Excel Charting & Pivots
    Replies: 12
    Last Post: 09-08-2013, 04:39 PM
  2. [SOLVED] Running totals
    By JimDandy in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-11-2012, 05:39 PM
  3. VBA for running totals
    By STarloff in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-30-2011, 02:41 PM
  4. Running total of multiple running totals
    By ashncg in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-09-2011, 05:20 PM
  5. Running Totals
    By stacy.mcmillan@comcast.net in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-10-2006, 04:00 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