Forum Discussion
Using Average and vlookup together
I have 14 solar panels on the roof of my house and I get a daily reading for the days production. I have created a spreadsheet showing that daily production for each day. I have a running total using...
That's easy: the AVERAGE function ignores blank cells. In C370:
=AVERAGE(C3:C368)
Fill to the right.
You may try to play with PivotTable, simple variant is attached.
