Array data on a different sheets? Help please

**Ahoop** · 05-23-2013, 02:06 PM

New to this website.

Is it possible to create an array on one worksheet and pull data from a different sheet?

I am trying to review monthly data defect types which are on one tab. I have created a review on the same sheet in order to get the correct information. however when I do a filter the review section is hidden. I would like to move the array formulas to a different review tab for easier data review.

The file is attached for your review.

**FDibbins** · 05-23-2013, 02:23 PM

Hi and welcome to the forum

You could just have moved/cut to the other sheet, but try these simpler formulas instead,,,,

=SUMIFS('2013'!$V$5:$V$1692,'2013'!$K$5:$K$1692,RIGHT('2013'!W5,1),'2013'!$T$5:$T$1692,'2013'!$Y$4)
=SUMIFS('2013'!$L$5:$L$1692,'2013'!$K$5:$K$1692,RIGHT('2013'!W5,1),'2013'!$T$5:$T$1692,'2013'!$Y$4)

**Ahoop** · 05-23-2013, 02:37 PM

Thanks. I tried to copy and move the formulas. They work on the initial sheet, but when I add them to the different sheet the formulas do not work.

Aaron