J
jesmin
Hi There:
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 col
when value of Sheet1 colA is 10. I tried. I think I am having synte
problem
Sheets("Sheet2").cells(1,1).formular1c1="=SUMIF(Sheets("Sheet1")!A1:A3,10,Sheets("Sheet1")!B1:B3)
Would appreciate if anyone can help. Thanks in advance
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 col
when value of Sheet1 colA is 10. I tried. I think I am having synte
problem
Sheets("Sheet2").cells(1,1).formular1c1="=SUMIF(Sheets("Sheet1")!A1:A3,10,Sheets("Sheet1")!B1:B3)
Would appreciate if anyone can help. Thanks in advance