average between events

  1. J

    Calculate an average number of days or weeks between deliveries

    I have a large spreadsheet. column A has sequential list of dates 2005 - current date. Column G has entries for delivery (numerical amount) on the actual delivery date (corresponding with Column A). I would like to determine the average number of days/weeks between deliveries. All cells in...
    • Joeclupis
    • Thread
    • average between events column date deliveries delivery
    • Replies: 3
    • Forum: Excel Questions
  2. P

    Calculate average between columns

    Hi all, Thanks for any help you can give. I have a spreadsheet of data, that has a number of columns which represent various stages of a process from entry date to completion date and stages in between. I am looking to calculate an average between various stages in the process, by months so I...
    • phils
    • Thread
    • average between events sumproduct ; -- ; countif
    • Replies: 0
    • Forum: Excel Questions
  3. M

    Need average days between transactions

    I have a table of sales with fields for salesperson ID, date key, and sales amount. Each salesperson may occur between 1 and 100 times in the table depending on whether she sold one order or 100. I am trying to calculate the average duration in days between each sale. For example assume a...
    • MrChuckles
    • Thread
    • average between events date difference frequency
    • Replies: 4
    • Forum: Power Tools

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
Back
Top