GSNexcel
New member
- Joined
- Oct 20, 2015
- Messages
- 8
- Reaction score
- 0
- Points
- 0
Hi,
I need a formula to find a daily average but my columns are monthly totals. I also need it to ignore the months that are zero, therefore I can't sum and divide by the number of days in the year. For example the monthly totals are Jan 10, Feb 12, March 0, April 41, May 0, June 15, July 62, August 5, September 0, October 24 - I need a daily average ignoring the monthly totals that are zero.
Thanks
I need a formula to find a daily average but my columns are monthly totals. I also need it to ignore the months that are zero, therefore I can't sum and divide by the number of days in the year. For example the monthly totals are Jan 10, Feb 12, March 0, April 41, May 0, June 15, July 62, August 5, September 0, October 24 - I need a daily average ignoring the monthly totals that are zero.
Thanks