Formula Question: Return a Value if a Cell Contains a Letter within a Text String

[Studk22]

Hi,

I have a cells drawing information from a table. In this table I have model numbers to depict products in one column. In another column I have sales totals for those model numbers. I would like to sum the sales for those model numbers if the model number contains an S.

Conveniently, these model numbers will always have the letter S at the end of the text string so I have been using this formula to try to sum the sales:

=SUMIFS(Sheet1!AQ10:AQ29991,(Right(Sheet1!D10:D29991,1)),"S")

However on future formulas I will need to sum sales based on other possible letters which will not always come last in the model number.

Even when I tried to do a trial formula to figure out the answer the following would not work:

A1 = 22

=IF(RIGHT(A1,1)=2,"Yes","No")

This returned the answer "No" which is incorrect.

Ideas?

 

[Aladin Akyurek]

Whoa. The "--" is an "if"? I've never seen that before. Are there more of these fabulous function shortcut / add-in / thingies?

Thank you! This is great!

Here some links on what they are for...

http://www.mrexcel.com/forum/showthread.php?t=202204

http://www.mrexcel.com/forum/showthread.php?t=128907

http://www.mrexcel.com/forum/showthread.php?t=70547 (post #8)

 

[RebeccaC]

Ahh, I see. Sweet. Thanks again!