Converting SumIf to VBA - Type Mismatch error

[Phitur]

I'm trying to convert this formula to VBA code:

=SUMIF(I:I,N3,G:G)

Cells(i, col6).Value = Application.SumIf(Range(col1 & _
  Chr(58) & col1), Cells(i, col2), (Range("G:G")))

Where col1 = "I"
col2 = "N"
i = 3

I get a type mismatch error in VBA; however, the formula runs fine in Excel. How do I resolve this problem?

Thanks

 

[Jonmo1]

Not sure WHY this is the problem...

But when I run it like this it errors

Cells(i, col6).Value = Application.SumIf(Range(col1 & _
  Chr(58) & col1), Cells(i, col2), (Range("G:G")))

If I run it like this, it works

Cells(i, col6).Value = Application.SumIf(Range(col1 & _
  Chr(58) & col1), Cells(i, col2), Range("G:G"))

Again, not sure why....

 

[Phitur]

Dang. I completely overlooked that. I found that in my research this morning too and knew you couldn't do that.

Thanks!