Hi
I need some help. I have multiple data sets on a given day which I would like to average by day, whilst excluding blanks and zeros. As follows:
<tbody>
</tbody>
I would like to use a formula that returns a daily average whilst excluding zeros and blank cells. For example, the daily average for the 19th of July 2015 should be 4.45. I would like to be able to drag and copy this formula across large data sets, resulting in a list of average data sets by day. For example:
7/19/2015 - 4.45
7/20/2015 - 1.78
8/7/2015 - 29.9
etc
Thank you for your help.
I need some help. I have multiple data sets on a given day which I would like to average by day, whilst excluding blanks and zeros. As follows:
| 7/19/2015 | 5.26 |
| 7/19/2015 | 6.84 |
| 7/19/2015 | 5.97 |
| 7/19/2015 | 3.39 |
| 7/19/2015 | 3.06 |
| 7/19/2015 | 3.26 |
| 7/19/2015 | 3.34 |
| 7/20/2015 | 1.99 |
| 7/20/2015 | 0.74 |
| 7/20/2015 | 1.64 |
| 7/20/2015 | 1.45 |
| 7/20/2015 | 2.22 |
| 7/20/2015 | 2.31 |
| 7/20/2015 | 2.11 |
| 7/20/2015 | |
| 7/29/2015 | 0.00 |
| 8/7/2015 | 0.00 |
| 8/7/2015 | 43.00 |
| 8/7/2015 | 35.00 |
| 8/7/2015 | 32.00 |
| 8/7/2015 | |
| 8/7/2015 | 35.69 |
| 8/7/2015 | 34.25 |
| 8/8/2015 | 33.19 |
| 8/8/2015 | 31.63 |
| 8/8/2015 | 0.00 |
<tbody>
</tbody>
I would like to use a formula that returns a daily average whilst excluding zeros and blank cells. For example, the daily average for the 19th of July 2015 should be 4.45. I would like to be able to drag and copy this formula across large data sets, resulting in a list of average data sets by day. For example:
7/19/2015 - 4.45
7/20/2015 - 1.78
8/7/2015 - 29.9
etc
Thank you for your help.
