daily average

  1. E

    Calculating average based on different amounts of blank cells

    Hello, I have a table of moths captured in a trap every few days. I want to make a chart that would show me the daily average. Note that the amount of days between each capture varies. See the example table below, I am looking for a formula that could give me the the third column ("average moths...
    • Elrond
    • Thread
    • average per day blanks cell daily average different amounts
    • Replies: 4
    • Forum: Excel Questions
  2. D

    I need help writing a Daily Average Formula

    Howdy, I have a problem that I can't figure out, and I'm hoping someone here can give me a hand. For the past several years I have been keeping a record of how far I walk/run/cycle each day via Excel. It has worked great for letting me see my average year by year. However, I have one Excel...
  3. N

    Daily Average of Unique Customers Making A Transaction

    I have a data set with a list of transactions made by 30k customers this year. Each customer might make anywhere from 1 to dozens of transactions a year. I would like to calculate a daily average of the number of customers who make a transaction on each day of the year. (not worried about how...

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