Forum Discussion

blackey's avatar
blackey
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...
excel
blackey's avatar
blackey
Copper Contributor
Dec 22, 2020

HansVogelaar 

 

Thank You. I thought I had to use the date or actual cell numbers

 

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Dec 22, 2020

blackey 

You may try to play with PivotTable, simple variant is attached.

Resources