I have 2 columns... A & B that need to match with 2 other columns in
another sheet (Sheet2.A & Sheet2.B) before I add the values in column
C. I did SUMIF(A2:B1000;SHEET2.A2:B2;C2:1000) but it gives me a #VALUE
error. How should I write my formula?
I appreciate your help.


--
maricelsy
------------------------------------------------------------------------
maricelsy's Profile: http://www.excelforum.com/member.php...o&userid=36383
View this thread: http://www.excelforum.com/showthread...hreadid=561543