Using Average and vlookup together

%3CLINGO-SUB%20id%3D%22lingo-sub-2002031%22%20slang%3D%22en-US%22%3EUsing%20Average%20and%20vlookup%20together%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2002031%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%2014%20solar%20panels%20on%20the%20roof%20of%20my%20house%20and%20I%20get%20a%20daily%20reading%20for%20the%20days%20production.%20I%20have%20created%20a%20spreadsheet%20showing%20that%20daily%20production%20for%20each%20day.%20I%20have%20a%20running%20total%20using%20the%26nbsp%3B%3DSUM(C3%3AC368)%20formula%20but%20I%20want%20to%20divide%20that%20with%20the%20number%20of%20days%20that%20have%20actually%20been%20read.%20See%20example%20attached%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2002031%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2002406%22%20slang%3D%22en-US%22%3ERe%3A%20Using%20Average%20and%20vlookup%20together%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2002406%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F659883%22%20target%3D%22_blank%22%3E%40blackey%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThat's%20easy%3A%20the%20AVERAGE%20function%20ignores%20blank%20cells.%20In%20C370%3A%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3DAVERAGE(C3%3AC368)%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EFill%20to%20the%20right.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

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

3 Replies

@blackey 

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

 

=AVERAGE(C3:C368)

 

Fill to the right.

@Hans Vogelaar 

 

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

 

@blackey 

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