Sum specific cells , divide cells that have numerical data, not 0, X by 52

I wish to sum the following data. Each “E” cell refers to a weeks income.

 

=SUM(E13,E21,E29,E37,E47,E55,E63,E71,E81,E89,E97,E105,E115,E123,E131,E139,E147,E157,E165,E173,E181,E191,E199,E207,E215,E225,E233,E241,E249,E257,E267,E275,E283,E291,E301,E309,E317,E325,E335,E343,E351,E359,E367,E377,E385,E393,E401,E411,E419,E427,E435,E446)

 

Once I have this sum, I want to divide it by the amount of cells that are NOT “0” before * 52.

 

So, essentially: Sum of all cells / cells that have numerical data, X 52

By: Paul Hunter

Leave a Reply

Your email address will not be published. Required fields are marked *