CODEWITHSUNDEEP
vbaformula
Amanda S
Amanda S

Reputation: 103

Countifs with a range and a value with formula in vba

I can't get this vba coding to work, please help:

Range("C1").Formula ="=Countifs(B2:B10,>&A1)"

I want to count cells with value greater than A1 in range B2:B10.

Thanks.

Upvotes: 0

Views: 289

Answers (1)

Dmitry Pavliv
Dmitry Pavliv

Reputation: 35863

Try this one:

Range("C1").Formula = "=COUNTIF(B2:B10,"">"" & A1)"

Upvotes: 1

Related Questions