Running formula

If depending on the cell's value you want to increase it's value with 1 VBA will be needed.

Kind of...but for example.

If It was to work out Bonus targets by month

Cell 1 has a y
Cell 2 has a y
but cell 3 has N
Cell 4 has a y

The employee still would get the bonus for the first two months but not teh third but then the 4th, so it would be a total of 3 y's resulting in 3 points?

Does that make it a bit clearer?

The if formula nearly worked, but when there was an N it wouldn't award any points?