sumif/countif on non-consecutive colums - array?

[Gerald Koch]

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

 

[JulieD]

Hi Gerald

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

give you the answer you're looking for?

Cheers
JulieD

 

[Gerald Koch]

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

thanks for your suggestion.