Using Average and vlookup together

Question

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 the&nbsp;=SUM(C3:C368) formula but I want to divide that with the number of days that have actually been read. See example attached

hansvogelaar · Answer

blackey&nbsp;
That's easy: the AVERAGE function ignores blank cells. In C370:
&nbsp;
=AVERAGE(C3:C368)
&nbsp;
Fill to the right.

blackey · Answer

HansVogelaar&nbsp;&nbsp;Thank You. I thought I had to use the date or actual cell numbers&nbsp;

sergeibaklan · Answer

blackey&nbsp;
You may try to play with PivotTable, simple variant is attached.

Forum Discussion

Using Average and vlookup together

3 Replies

Resources