Sumproduct

[58Spring]

Hi,

On the Data spreadsheet I am trying to retrieve from the FY2010toFY2012 rawdata spreadsheet but I keep getting "0" and "Value". same formulat different cells.

I don't know why. I'm attaching the spreadsheet

I am using the formula
=SUMPRODUCT(('FY2010 to FY2012 raw data'!A1:A5000="2011")*('FY2010 to FY2012 raw data'!D1:D5000="11")*('FY2010 to FY2012 raw data'!E1:E5000))

I want to look up on the FY2010toFY2012 rawdata from Column A "2011" and from Column B "11" and add the data that meets that criteria in Column E and then I want to do that again fo Column F.

Any help with this is so appreciated.

Lori

[icestationzbra]

put this in C5 and drag-fill down to C7, and then right to column N:

Please Login or Register  to view this content.

by the way, this is a regular formula - no need for CTRL+SHIFT+ENTER.

since you are on version 2007, make use of SUMIFS, instead of SUMPRODUCT, because of the latter's negative effect on performance.

[dwint]

in C6

Please Login or Register  to view this content.

in C14

Please Login or Register  to view this content.

copy to right and down

please see attached file

[58Spring]

Thank you it works! I learned something new as well. Enjoy the day

[58Spring]

Wonderful that works too. I really appreciate the help. I see what I was missing...needed to refer to my "sheet3".