SUMIFS Excel 2007 with wild cards & case sensitivity

[nsurani]

I have a table in which i want to search for the values whose first two characters are ignored and the third character should be "A" in upper case. If someone can help urgently.

Thank you.

 

[barry houdini]

Hello nsurani, welcome to MrExcel

You mention SUMIFS, if you want to sum column B where third letter in column A is upper case "A" then try

=SUM(IF(EXACT(MID(A1:A100,3,1),"A"),B1:B100))

that's an "array formula" that needs to be confirmed with CTRL+SHIFT+ENTER

 

[nsurani]

Thank you for your reply.

Is there anyway that i can use wildcards?