Excel gurus

[Red Kent]

Right.

 

I have a column of cells A1:A50.

 

If the letter S appears in any of those cells I want the total to incriment x 11. ie 1 x S = 11, 2 x S =22, 3 x S = 33 etc etc.

 

The main thing is there could be other letters and numbers inserted into those cells and I dont want to take them into account - only the letter S.

 

Anyone out there than can help please ?

[SkippyjonJones]

This post is not viewable to guests.

You can sign in to your account at the login page here

If you do not have an account then you can register here

[Red Kent]

This post is not viewable to guests.

You can sign in to your account at the login page here

If you do not have an account then you can register here

Edited September 8, 2010 by Kev

[Red Kent]

This post is not viewable to guests.

You can sign in to your account at the login page here

If you do not have an account then you can register here

[Gerry]

This post is not viewable to guests.

You can sign in to your account at the login page here

If you do not have an account then you can register here

[Red Kent]

This post is not viewable to guests.

You can sign in to your account at the login page here

If you do not have an account then you can register here