On 06/05/2015 18:13, John Rumm wrote:
=IF( expression 0, expression, " ")
Maybe this will help explain it better.
The formula at the top should pick up under the % heading the number of
cells that have an entry. As you can see only 3 of those cells have an
entry which returns arrowed 58.75 which is the wrong answer.
The calculation should be 100+60+75 = 235 / 3 = correct answer of 78.3
http://i64.photobucket.com/albums/h1...psql11doqn.jpg