problem with conditional format

[davegreen100]

hello

i have the following formula in a cell in sheet1, i want it to look from A3:A11 in sheet2 and for any row which matches the value in sheet1!A2, sum the values from sheet2!D3:D11. If there is no match then return 0.

but even with the correct data in sheet2, 0 is always returned

=SUM(IF(Sheet2!A3:A11=Sheet1!A2,Sheet2!D3:D11,0))

any ideas what i'm doing wrong?

dave

 

[Johnny C]

I may be wrong, but I think the result of the IF statement would give you an error, not a range. You need a SUMIF

Try this:
=SUMIF(Sheet2!A3:A11,Sheet1!A2,Sheet2!D3:D11)

 

[Norie]

Why not use the SUMIF function?

=SUMIF(Sheet2!A3:A11, Sheet2!A2, Sheet2!D3:D11)

 

[davegreen100]

great, thanks guys