Y,Y,Y? (Excel 2002)

[wskinnr]

Hi there, I'm new here and could do with some help! I'm currently using Excel 2002 (it's all my workplace has!). I have created a worksheet that counts the number of times an item can be used before it needs to be replaced. i have put in a formula that, when a Y is put in one cell, the count is zeroed and continues from there. What I want to do is to make it respond the same way to other letters. If anyone can help it would be much appreciated. I'm no excel expert so layman's terms would be fantastic. Thanks.

 

[CWatts]

You'll need to provide a bit more info, like the structure of your data and the actual formula, but this may help.

I'm assuming you have something that basically says =IF(C4="Y",0,B4+1)
which basically says if C4 is Y, then reset the count to zero, otherwise keep adding.

C4="Y" is a true false test if there is a Y in the cell or not.
You can replace that with OR(C4="X",C4="Y",C4="Z") which will test if it equals X, Y or Z
A third option is to replace that with C4<>"" which is a test that says if C4 is not mepty then zero it.

Hopefully one of those will help, but if not, you'll need to give us more detail.

 

[wskinnr]

You'll need to provide a bit more info, like the structure of your data and the actual formula, but this may help.

I'm assuming you have something that basically says =IF(C4="Y",0,B4+1)
which basically says if C4 is Y, then reset the count to zero, otherwise keep adding.

C4="Y" is a true false test if there is a Y in the cell or not.
You can replace that with OR(C4="X",C4="Y",C4="Z") which will test if it equals X, Y or Z
A third option is to replace that with C4<>"" which is a test that says if C4 is not mepty then zero it.

Hopefully one of those will help, but if not, you'll need to give us more detail.

thank you very much. much appreciated. i also want to count the number of occurences of each letter across multiple workbooks, is it possible? would countif work?