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