sum date range

  1. P

    LOOP with non blank cell

    Hi everyone, Im learning VBA and I have this code Sub [CODE]SmartRunningTotals() Dim rng As Range Dim cell As Range Dim lastRow As Long Dim totalTime As Double ' I'm assuming your time column is in column A lastRow = Range("A" & ActiveSheet.Rows.Count).End(xlUp).Row...
  2. P

    LOOP with non blank cell

    Hi everyone, Im learning VBA and I have this code Sub SmartRunningTotals()</pre> Dim rng As Range Dim cell As Range Dim lastRow As Long Dim totalTime As Double ' I'm assuming your time column is in column A lastRow = Range("A" & ActiveSheet.Rows.Count).End(xlUp).Row...
  3. J

    Pie Chart Individual Sums

    Hi, I have a few teams working for me and each team resolves tickets (Alpha, Bravo and Charlie let's say). I want to create a pie chart to compare the teams so each segment is a sum of the numbers. I can do a chart for the individual people. I can do a chart for each team that picks a person...
  4. J

    Sum a range of data based on date range

    Hi, Im new to the boards, and am relatively inexperienced in excel. I have a recurring problem with one of my spreadsheets. I have a summary sheet that pulls data from a variety of sources. One of the sources is a monthly report that is generated daily. Dates down column A for the month...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top