formula if two cells contain specific text add "x" amount

[danj4fsu]

I am trying to have a cell add "25" if a two range of cells contain specific text. For instance, if E12:E45 contain "Shater" AND F12:F45 contain "Held" add 25.

TIA

 

[danj4fsu]

As you can see, it is important to include the details of exactly what you want, as if you are too brief, it can be unclear or interpretted in different ways.
Just something to be mindful of in future posts, so you increase the likelihood of getting answers that do what you want.

Thank you. I would consider me to be basic/intermediate with my Excel knowledge and because of that, wasn't even sure how to ask. Either way, I appreciate the quick responses.

 

[Joe4]

Thank you. I would consider me to be basic/intermediate with my Excel knowledge and because of that, wasn't even sure how to ask. Either way, I appreciate the quick responses.

You are welcome.

A good way to approach it is this way: How would I describe the question to someone who has never seen this before and has no knowledge of what I am trying to do?
I don't mean the technical Excel side of it, just describing the question in plain English, in detail.

As you post more questions, I am sure it is something that you will get more of a feel for.
Also note that there is a Sticky out there with some good tips: https://www.mrexcel.com/forum/board-announcements/127080-guidelines-forum-use.html

Happy Excel-ling!