Running formula

Hello all

Please can someone tell me what formula I can use to add a running total with variables? For example:

If I have 4 cells with different numbers or letters in them I want it to be able to look at one cell and if it equals x then to add 1, then to look at the next cell and if this also equals x then add one and move to the next cell but if it doesn't then to stop?

Does that make sense and is it even possible?

Thanks

James

if the numbers start in A1, in b2 put

Please Login or Register  to view this content.

Is that what you mean?

Regards

Dav

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?

=countif(your_range,"y")

Thanks again arthurbr

However, is there a way of adding these different - so if a month has a harder target it's worth more points, so month 2 would be worth 4.
Or a way of adding points to the Y's? so it doesn't just equal 4?

Thanks!!

James

It's possible but you will have to define what happens when, define targets, number of points depending on target, etc...
Adding a sample of your data and what you want to do would be helpful