J
jn
I have four columns (a1:d1) that list numbers, with the
sum listed in e1. I need e1 to not only sum a1:d1, but to
divide it by the number of actual inputs, i.e. if a1 and
c1 are the only ones with numbers, sum/2. If all (a1:d1)
have numbers, sum/4. Any help will be greatly
appreciated.
sum listed in e1. I need e1 to not only sum a1:d1, but to
divide it by the number of actual inputs, i.e. if a1 and
c1 are the only ones with numbers, sum/2. If all (a1:d1)
have numbers, sum/4. Any help will be greatly
appreciated.
1)