CountIf Usage Across Two Worksheets

[Tuffman]

I can't get this code to run, I keep getting an error that says "Compile error: Invalid qualifier". I'm wanting to count the number of blue cars on the "Cars" worksheet in column J from rows 45-70. Then have that number shown in cell C10 on the Summary worksheet. Can someone help me understand why this isn't running?


Worksheets("Summary").Range("C10") = Worksheets("Cars").WorksheetFunction.CountIf(Range("J45:J70"), "Blue")

 

[Joe4]

Your sheet reference needs to go before the range reference, i.e.

    Worksheets("Summary").Range("C10") = WorksheetFunction.CountIf(Worksheets("Cars").Range("J45:J70"), "Blue")

 

[Tuffman]

Your sheet reference needs to go before the range reference, i.e.

    Worksheets("Summary").Range("C10") = WorksheetFunction.CountIf(Worksheets("Cars").Range("J45:J70"), "Blue")

Thank you Joe4, that worked perfectly!

 

[Joe4]

You are welcome.

Please note: When marking a post as the solution, please mark the original post containing the solution (and not your own post indicated that another post is the solution).
I have updated this one for you.