Forum Discussion

Copper Contributor

Dec 18, 2020

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...

Solar Averages.xlsx19 KB

excel

HansVogelaar

MVP

Dec 18, 2020

blackey

That's easy: the AVERAGE function ignores blank cells. In C370:

=AVERAGE(C3:C368)

Fill to the right.

blackey
Copper Contributor
Dec 22, 2020
HansVogelaar

Thank You. I thought I had to use the date or actual cell numbers
- SergeiBaklan
  Diamond Contributor
  Dec 22, 2020
  blackey
  
  You may try to play with PivotTable, simple variant is attached.
  Solar Averages.xlsx43 KB