[VBA] SumIf Errors

[ExcelNooberino]

Hello everyone,

I keep trying to achieve a formula that allows me to sum some cells in a different sheet than the one I wanted posted so I've developed a code such as this one below:

Sub SumData()
Dim LastRow As Long
Dim FirstRow As Long


LastRow = Sheets("Sheet1").Cells(Rows.Count, 1).End(xlUp).Row
FirstRow = Sheets("Sheet1").Range("H2").Row
Range("Home!A1") = Application.WorksheetFunction.SumIf(Range(Home!E" & FirstRow & ":Home!E" & LastRow & "), "EX20", Range(Home!H" & FirstRow & ":Home!H" & LastRow & "))

End Sub

I keep getting syntax errors and so on no matter how I switch it up, I need some help!

 

[Oaktree]

Welcome to the board.

Assuming you're searching for the text string "EX20" and not the value from cell EX20, try:

Sub SumData()
Dim LastRow As Long
Dim FirstRow As Long


LastRow = Sheets("Sheet1").Cells(Rows.Count, 1).End(xlUp).Row
FirstRow = Sheets("Sheet1").Range("H2").Row
Range("Home!A1") = _
    Application.WorksheetFunction.SumIf(Range("Home!E" & FirstRow & ":Home!E" & LastRow), _
                                        "EX20", _
                                        Range("Home!H" & FirstRow & ":Home!H" & LastRow))

End Sub

 

[ExcelNooberino]

Thanks in advance!
That did fix the issue, however, the I guess the sheet I want it's not being recognized cuz the value I get from that sum keeps staying on zero :/

 

[ExcelNooberino]

Nevermind, silly of me.. I forgot to change the Home! to Sheet1! in the formula, now it works! Thank you so much man! :D