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

Hi Gerald

does
=AVERAGE(A1:A10,C1:C10,E1:E10)

give you the answer you're looking for?

Cheers
JulieD

"Gerald Koch" <Gerald wrote in message
...
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

yeah, found it... was thinking way to complicated in the beginning...

thanks for your suggestion.

"JulieD" wrote:

Hi Gerald

does
=AVERAGE(A1:A10,C1:C10,E1:E10)

give you the answer you're looking for?

Cheers
JulieD

"Gerald Koch" <Gerald wrote in message
...
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