If Statements

[kathyvn]

I have sheet 1 and sheet 2, I would like to pull the following information from sheet 1 to sheet 2.

if(sheet1c2:c200 equals 19 and sheet1d2:d200 equals sheet2a3 then sum sheet1e2:e200)

could you please tell me what formula to use?
Thank you

 

[MrKowz]

Welcome to the forums!

Excel 2003 or older:
=SUMPRODUCT(--(Sheet1!C2:C200=19),--(Sheet1!D2:D200=Sheet2!A3),Sheet1!E2:E200)

Excel 2007 or newer:
=SUMIFS(Sheet1!E2:E200,Sheet1!C2:C200,19,Sheet1!D2:D200,Sheet2!A3)

 

[kathyvn]

I used the sumifs statement you sent me in and I am getting a value error? I am using Windows XP. What reasons would I get a value error?

 

[MrKowz]

My apologies, I left out the quotes:

=SUMIFS(Sheet1!E2:E200,Sheet1!C2:C200,"19",Sheet1!D2:D200,Sheet2!A3)

 

[kathyvn]

Thank you very much - I renamed my sheet2 and it worked

Again thank you