Arrays have to be the same size in array formulae, so unless yours are
the same in both sheets then you will have to make do with separate
formulae for each range and then combine them.

Perhaps you can give us some idea of what you are trying to do ...

Hope this helps.

Pete

On May 30, 9:36 pm, cass calculator wrote:
Is it possible to do an array formula using 2 ranges that are in
seperate sheets. I have so much data that it exceeds the number of
rows in excel and needed to be put on two different sheets. Is there
a way to do an array formula on the total range instead of having to
do formulas on each half?

Thanks,

Joshua