WorksheetFunction.CountIf, with non-numeric

[London_Calling]

These things drive me utterly bonkers - playing 'where to put the quotes' is like playing battleships as a kid. I've given it a decent go this morning, I'm hoping one of you have better luck....

totalNonNumeric = WorksheetFunction.CountIf(Range(("Cells(i + UBound(resultsArr1) - totalMatches - 1, colA), Cells(UBound(resultsArr1) + i, colA"), "/")))

Fwiw, I started out with a working WorksheetFunction.Sum variation:

calanderLiability = WorksheetFunction.Sum(Range(Cells(i + UBound(resultsArr1) - totalMatches - 1, colA), Cells(UBound(resultsArr1) + i, colA)))

I've been looking at colon instead of comma, where to put brackets and where to put quotation marks.... Any ideas gratefully received...

 

[Richard Schollar]

Perhaps this:

totalNonNumeric = WorksheetFunction.CountIf(Range(Cells(i + UBound(resultsArr1) - totalMatches - 1, "A"), Cells(UBound(resultsArr1) + i, "A")), "/")

 

[London_Calling]

Richard,

Thanks for looking in. It took me a moment to see what you'd done there!

I should have been clearer; 'colA' and 'colB' are (inappropriately named) variables. I'll restate it to aviod unnecessary confusion:

totalNonNumeric = WorksheetFunction.Sum(Range(Cells(i + UBound(resultsArr1), varA), Cells(UBound(resultsArr1), varA)))

^ This obv. is fine as it's SUM with appropriate args.

Converting it to COUNTIF is where I'm stuck:

totalNonNumeric = WorksheetFunction.CountIf(Range(Cells(i + UBound(resultsArr1), varA):Cells(UBound(resultsArr1), varA, "/")))

^ rubbish

As mentioned, I think it's just getting the colon or comma right, the brackets or quotation marks.... hope that's a bit simpler ...

 

[London_Calling]

In a blinding flash of common sense I seem to have resolved this. Hurrah!

Thanks for your interest, Richard.