Running total of sales prior to now.

[shophoney]

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

 

[Hurkk]

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

 

[shophoney]

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]"),"")