countif with addition or subtraction

[ammartino44]

Can you do a countif like this? Countif (a1:a5, a1=a2+1) ? I guess I want to know if you can do conditionals and modify cell value with mathematical operators.

[Richard Buttrey]

You can do it in the sense that it won't return an error since a1=a2+1 will always evaluate as either True or False. But that's then meaningless in the Countif function anyway.

You can use stuff like a2+1