N Harkawat wrote...
Not unless you can in a separate area pastelink these non-contiguous
ranges
into a single contiguous range.

"GaryF" wrote in message
The data I wish to perform IRR calcs on is in different ranges in the
worksheet. Is there any way to concatenate these ranges so they
appear to
IRR as one contiguous range?

It's possible to consolidate multiple ranges into a single array as
long as there's a regular pattern to the different ranges. For example,
the formula

=IRR(N(OFFSET($B$2:$B$11,MOD(ROW($1:$20)-1,10),
2*INT((ROW($1:$20)-1)/10),1,1)),-0.9)

calculates the IRR of the cashflow starting in B2:B11 and continuing in
D2:D11.