Result of SUMIF in different worksheet

[pwillia]

Hello,

Just a quick (and I'm sure, easy) question regarding SUMIF across worksheets. Basically I have written my SUMIF to work perfectly on my first worksheet which is fine. However, instead of the output being on the first worksheet (same worksheet as SUMIF), I would like the output to be displayed on my second work sheet.
Here's what I have so far:

Range("sheet2name!a3:a26").Formula = "=SumIf(sheet1name!$U$4:$u$150, sheet1name!ae3, sheet1name!$ab$4:$ab$100)"

As you can see I am referencing the sheets at every point in the statement. This isn't working, can somebody please help me with why? I have tried numerous variations, but I'm new to working across sheets.

Thank you so much for your time!

Pete.

 

[AlphaFrog]

Try somethhing like this...

Sheets("Sheet2").Range("A3:A26").Formula = "=SumIf(Sheet1!$U$4:$U$150, Sheet1!AE3, Sheet1!$AB$4:$AB$100)"

 

[pwillia]

Thank you for your help, this works perfectly. I also realised I had an error due to one spelling mistake! Thank you once again