Thread
:
sumif/countif on non-consecutive colums - array?
View Single Post
#
3
Gerald Koch
Posts: n/a
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
Reply With Quote