JARichard74
Board Regular
- Joined
- Dec 16, 2019
- Messages
- 114
- Office Version
- 365
- Platform
- Windows
The result of the formula should be something like this:
=IF(OR(A19<2,A19<$B$18-2,A19>$B$18+2),COUNTA($A$19:$A$24),COUNTIFS($A$19:$A$23,">="&2,$A$19:$A$23,"<="&$B$18+2,$A$19:$A$23,"<"&A19)+1). Formula used to do a RANK IF
The error is most likely a missing " and/or & starting with COUNTA part. The Condition should be ok as I am already using the same condition in another formula
=IF(OR(A19<2,A19<$B$18-2,A19>$B$18+2),COUNTA($A$19:$A$24),COUNTIFS($A$19:$A$23,">="&2,$A$19:$A$23,"<="&$B$18+2,$A$19:$A$23,"<"&A19)+1). Formula used to do a RANK IF
The error is most likely a missing " and/or & starting with COUNTA part. The Condition should be ok as I am already using the same condition in another formula
VBA Code:
"=IF(Condition,COUNTA(B" & startRow & ":B" & endRow & "),COUNTIFS(B" & startRow & ":B" & endRow & ", >= 2,B" & startRow & ":B" & endRow & ", <= " & Mrnge & " + 2,B" & startRow & ":B" & endRow & ", < B" & startRow & ")+1)"