Why isn't this SumIF formula working

[pearl]

Greetings,

Can someone explain why the code shown below working. When it is highlighted the correct forumula shows up.

which would be the following:

"sumif("b(x):b","<>Exclude", "e(x):e")"

"x" and "y" vary for each run.

With ActiveCell
Set prjct = Range(.Offset(-mycount + 1), .End(xlUp))

End With

ActiveCell.Offset(0, 3).Select


With ActiveCell
Set Rng = Range(.Offset(-mycount + 1), .End(xlUp))
.Formula = "=SUMIF(" & prjct.Address(RowAbsolute:=False, _
ColumnAbsolute:=False) & ") ,""<>Exclude""," & Rng.Address(RowAbsolute:=False, _
ColumnAbsolute:=False) & ")"
End With

Thanks