Jump to content
I will no longer be developing resources for Invision Community Suite ×
By fans, for fans. By fans, for fans. By fans, for fans.

Excel gurus

Red Kent

By Red Kent
in The Swanny

 Share

Recommended Posts

Red Kent

Red Kent

Posted
Posted

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 ?

Red Kent

Red Kent

Posted
  • Author
Posted (edited)

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 by Kev

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share
Go to topic listing

  • Recently Browsing   0 members

    • No registered users viewing this page.

Home

Notifications

PMs
×
×
  • Create New...