How cell ranges are handled by worksheet functions/row column matc
 

If you pass a cell range to a function like SUM e.g.

=SUM($A$1:$D$1), all of the range is used and SUM sums the cells A1, B1, C1
and D1.

However if you pass the same cell range to a function like IF e.g.

=IF(5 < 10, $A$1:$D$1, 99)

The range acts like either cell $A$1, $B$1, $C$1 or $D$1 according to the
column of the cell the IF formula is in.

I need to know how a cell range will be handled by every possible worksheet
function. There are tens of different worksheet functions. How can I obtain
this information apart from going through every function and trying to work
out how each one deals with cell ranges individually?

I have heard functions like SUM referred to as "aggregating" functions. Is
this the correct term? How can I get hold of a definitive list of all
"aggregating" functions?

How cell ranges are handled by worksheet functions/row column matc
 

Try posting in Worksheet Functions instead of programming, since this has
nothing to do with programming.

--
Regards,
Tom Ogilvy


"Martin" wrote in message
...
If you pass a cell range to a function like SUM e.g.

=SUM($A$1:$D$1), all of the range is used and SUM sums the cells A1, B1,
C1
and D1.

However if you pass the same cell range to a function like IF e.g.

=IF(5 < 10, $A$1:$D$1, 99)

The range acts like either cell $A$1, $B$1, $C$1 or $D$1 according to the
column of the cell the IF formula is in.

I need to know how a cell range will be handled by every possible
worksheet
function. There are tens of different worksheet functions. How can I
obtain
this information apart from going through every function and trying to
work
out how each one deals with cell ranges individually?

I have heard functions like SUM referred to as "aggregating" functions. Is
this the correct term? How can I get hold of a definitive list of all
"aggregating" functions?