sumif in VBA

Need a little help with a simple sumif. I dont know why it keeps telling me the Sumif formula has a sintaxe error.

 Range("G & rw").Value = Application.WorksheetFunction.SumIfs(range("N:N"),Range("C & rw),Range("S:S")

It sais it expected a text separator were i input colum S:S.

This looks like a very simple problem, but i couldnt find anything alike here in the forum, and i cant solve it.

Sub Macro1()
Dim LR As Integer
Dim rw As Integer

LR = Range("C" & Rows.Count).End(xlUp).Row
    
    For rw = 2 To LR

        If Not IsEmpty(Range("C" & rw).Value) Then

    Range("G & rw").Value = Application.WorksheetFunction.SumIfs(range("N:N"),Range("C & rw),Range("S:S")

        End If

        If Range("G" & rw).Value = 0 Then
            Range("G" & rw).Value = "-"
            Range("F" & rw).Value = "N緌"
        ElseIf Range("G" & rw).Value <> 0 Then
            Range("F" & rw).Value = "Sim"
        End With
 
    Next rw
End Sub

I fixted it, but it is giving me error '438' - object doesn't support this property or method

haha i knew it was just something stupid. Thank you

I found a couple more errors after my original post and edited my response. You may have copied my response before I made those changes. Are you using the latest version? Please try again.

If it still doesn't work, show exactly what you are using and give the value of rw when the error occurs.

I forgot to mention i use excel 2002. But I would guess this function is available to this version anyways.

i've tryed a few things, and it keeps sending the same msg.

Sub Macro1()
Dim LR As Integer
Dim rw As Integer
Dim RSum As Integer

LR = Range("C" & Rows.Count).End(xlUp).Row
RSum = Range("n" & Rows.Count).End(xlUp).Row

    For rw = 2 To LR

        If Not IsEmpty(Range("C" & rw).Value) Then

        'Range("G & rw").Formula = "=somase(("N2:N60"),("C"&rw), ("S2:S"&RSum))


        
        Range("G" & rw).Value = Application.WorksheetFunction.SumIfs(Range("N2:N" & RSum), Range("C" & rw), Range("S2:S" & RSum))

        End If

        If Range("G" & rw).Value = 0 Then
            Range("G" & rw).Value = "-"
            Range("F" & rw).Value = "N緌"
        ElseIf Range("G" & rw).Value <> 0 Then
            Range("F" & rw).Value = "Sim"
        
        End If
    Next rw
End Sub

So excel 2002 does not suport sumif in VBA? I can do the sumif funtion in the normal excel, it only gives me this messege while i try to insert the function in visual basic mode. Then if this is the case, how could I get this done with other formulas?

Sorry, didn't realize that was not available in 2002. I have not used VBA in any version prior to 2003.

SUMIFS was introduced in Excel 2007. You are only using one criterion so you could use SUMIF (you must change the syntax to match). If SUMIF is not available in your version of Excel, this is how you could use SUMPRODUCT:

Application.WorksheetFunction.SUMPRODUCT(Range("N2:N" & RSum) * --(Range("C" & rw) = Range("S2:S" & RSum)))

I can't test this properly without your file but give it a try.

GOT IT! its not 'sumifs'... its just 'sumif'

thank you!