VBA SumIf Result "TRUE" instead of a number

[tbone90s]

Hi guys,

(Hopefully) quick question for you. I'm trying to use SumIf and it's been giving me a heck of a time all afternoon. I've tried using the worksheetfunction.sumif route and couldn't seem to get the syntax correct. I'd prefer the worksheetfunction route, as I don't need the formula stored, but it would be great to have both of these pieces of code for reference online - I scoured Google, and the examples I found were pretty weak.

I've recorded the macro (hence the R1C1 references in the second example) and had it work perfectly, but when I replaced row references with my variables, it went back to displaying "TRUE." I'm including all the code here.

Variables:
expr = 3 to 38 (For loop)
startrow = the starting row for the reference data
endrow = the ending row for the reference data
thresh = minimum threshold (a number)

Syntax error here:

Please Login or Register  to view this content.

Returns "TRUE" instead of the sum I'm looking for:

Please Login or Register  to view this content.

Recorded macro that works:

Please Login or Register  to view this content.

Thanks for all your help! Love the forum... It's been a great resource and I hope to one day be on the other end of the questions when I get a little better at this. :-/

[davesexcel]

I believe the first code was just entered wrong,

Please Login or Register  to view this content.

[tbone90s]

Right on, Dave! Your code worked like a champ! You're the man!

Thanks!

[royUK]

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save