I am trying to make a chart to record the generation of my solar panels.I want to enter te meter reading then caculate the daily generation and also average the daily generation,but as you can see I end up with a minus number in the daily generation column.how can I set this up so I can get a daily average.the calc is on sheet 2
Regards Troysie
Bookmarks