Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Where is the bug in my array? | Excel Discussion (Misc queries) | |||
Working with array equations | Excel Discussion (Misc queries) | |||
Transpose into a _working_ transposed array | Excel Discussion (Misc queries) | |||
VBA Import of text file & Array parsing of that data | Excel Discussion (Misc queries) | |||
Keeping Array values? | Excel Worksheet Functions |