var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: a problem of average formula
I'm facing a problem about average formula that I can not solve at the moment but I know it's quite simple for you.
My excel table is as follow:
a1 b1 c1 d1 e1 f1
0 3 2 0 5 =average(a1:e1)
the problem is I want to average only cells that is greater than 0 (the result must be 3.33, not 2)
Could anyone help me to solve above problem
thanks in advanced.
If only positive numbers and zero will be entered, then use this:
If negative numbers can also be used, then use this:
it works for me. thank you very much