Forum Discussion
SUM of numbers in a sequence
Hello. I have a billing report in Excel that I use to enter claims in a state system. The system requires me to enter a record for each date, along with the number of hours and the total amount. Ho...
Take a look on a sample file.
All you need to do is input your "Date From" and "Date To"
and it will automatically calculate the hours and amounts within that date.
Hi! My Access dBase actually creates the records. I don’t input them. I copy and paste them to Excel. I just thought I could create a formula in Excel that would calculate the amounts that were sequential in date. No worries. Maybe I need to look at the whole process from another angle. Happy New Year!
Hi gdougher (Happy New Year too)
My Access dBase ... Maybe I need to look at the whole process from another angle
#1 Instead of copy/paste from Access to Excel, why not using https://support.microsoft.com/en-us/office/about-power-query-in-excel-7104fbee-9e62-4cb9-a02e-5bfb1a6c536a (from Excel) to get the data from Access
#2 Once the records are gathered, aggregate as desired with Power Query and return the output to an Excel sheet:
The attached sample doesn't get the data from Access but it's fairly easy to setup
Any question feel free to ask
