I thought I had the correct formulas in but as soon as data was being placed week by week..I noticed the flaws.
I have D5 that will need to calculate the overall average monthly gas usage by my employer. The key is not to include blank cells into the average.
The second part to this is the individual averages (D8:32) also not including zeros/blank cells. I can't just divide by 52 because sometimes gas will not be purchased. So if a week doesn't have data in the cell, ($0.00) can I do a sum if equation to only average the cells with data accordingly?
I apologize about the size of the file...I dont know how to just save an individual sheet and send only that.
Bookmarks