Running total of sales prior to now.

shophoney

Board Regular
Joined
Jun 16, 2014
Messages
219
Hi, I have sales by the hour. Each hour I have a cell with the total sales.

I'm looking for the best way to have running total, but if the time is after now it will display 0.

1pm $200 $200
2pm $150 $350
3pm $ 75 $425

But if the time is after now then dont give the hourly totals.

So something with =now(), <1pm?

Thanks
 

Some videos you may like

Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.

Hurkk

New Member
Joined
Jan 17, 2018
Messages
13
Hey shophoney,

Assuming column A contains the time 1pm,2pm etc.. Make sure these values are configured are numbers and not strings

=IF(A1>HOUR(NOW()),SUM(200$,etc..),"")

Cheers,

Hurkk
 
Last edited:

shophoney

Board Regular
Joined
Jun 16, 2014
Messages
219
Hi, thanks for the response.

My issue might be with the TIME formula being a cubemember. See below, I only need the time part not the date.

=IFERROR(CUBEMEMBER("ThisWorkbookDataModel","[TIME].[TIME].&[1899-12-30T23:00:00]"),"")
 

Forum statistics

Threads
1,089,381
Messages
5,407,923
Members
403,171
Latest member
mayesmail12

This Week's Hot Topics

  • help please
    SORRY NOT ANY GOOD AT EXCEL SO HELP WOULD BE MUCH APPRECIATED this formula is in a sheet called ignore...
  • two formulas needed
    Hello, I'll try my best to explain this: First formula needed in Sheet1 cell A2: If Sheet1 cell B2 = Sheet2 cell B2 then return a 1. If not then...
  • Dynamic Counts
    Good afternoon, we are tidying up some data & the data seems to be growing quicker than we are tidying it up! What we confirm (by reviewing it...
  • Help Excel formula eliminate duplicate values and keep only 2 identical rows.
    as picture below column A has a duplicate value. but the values are not the same as the rule. sometimes 4 rows, sometimes 10 rows or 7 or 9...
  • Macro Compile Error Sub or Function not defined
    Hello, I am trying to run macros from a validation list, all macros have been created and run perfectly on there own but I'm getting a compile...
  • Last row combined with Current Region VBA
    I'm generally happy finding the last row of data through something like Lastrow = Cells(Rows.Count, "D").End(xlUp) but I don't always receive data...
Top