array range in seperate sheets

  • Thread starter Thread starter cass calculator
  • Start date Start date
C

cass calculator

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
 
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
 
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
Click to expand...

When you do a simple sum, it accepts multiple range arguments: i.e.
=sum(array1, array2, ...). I was wondering if you could do the same
thing in an array formula.
i.e.={sum((array1,array2)*(array1,array2))}

Thanks,

Joshua
 
Back
Top