Hi The
In my sheet1 I have:
colA colB
r1 10 5
r2 10 4
r3 15 10

I want to do a SUMIF in sheet2 at cell(1,1). I want to add sheet1 colB
when value of Sheet1 colA is 10. I tried. I think I am having syntex
problem
Sheets("Sheet2").cells(1,1).formular1c1="=SUMIF(Sh eets("Sheet1")!A1:A3,10,Sheets("Sheet1")!B1:B3)"


Would appreciate if anyone can help. Thanks in advance.


--
jesmin
------------------------------------------------------------------------
jesmin's Profile: http://www.excelforum.com/member.php...o&userid=29540
View this thread: http://www.excelforum.com/showthread...hreadid=508212