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 |
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 |