sumif/countif on non-consecutive colums - array?
Hey,
I am trying to calculate an average over several non-consecutive colums,
however, not all of the colums have values entered. How can I write a formula
to do this for me? I read that I should be using an arrayformula, but could
ot figure out how this works...
Thanks a lot in advance,
Gerald
|