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

 

[Joe4]

Welcome to the Board!

For instance, if E12:E45 contain "Shater" AND F12:F45 contain "Held"

Are you saying that EVERY cell in E12:E45 contains "Shater", or if ANY ONE cell in E12:E45 contains "Shater"?

 

[danj4fsu]

ANY ONE cell in e12:e45 contain "shater" and any one cell f12:f45 contain "held".

e12:e45 will either have Shater or Chase
f12:f45 will have held, cancelled, or rescheduled

These reps are paid $25 for each appointment held. So I want a cell that adds 25 if e12:45 has "specific name" AND f12:f45 has"held"

 

[Joe4]

Try this:

=IF(AND(COUNTIF(E12:E45,"Shater")>0,COUNTIF(F12:F45,"Held")>0),25,0)

 

[danj4fsu]

that put 25 in the cell but is not adding additional 25 for other occurrences of "shater" + "held"

 

[snjpverma]

Try this
=COUNTIFS(E12:E45,"Shater",F12:F45,"Held")*25

 

[danj4fsu]

In this instance, cell J15 should have $75 and J16 should have $50.

3 appointments for "shater" that were "held"
2 appointments for "chase" that were "held"

https://www.dropbox.com/s/pz6rnnftp3nm7dl/excel snip.JPG?dl=0

 

[danj4fsu]

That worked!, thank you!

 

[Joe4]

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.

 

[danj4fsu]

Try this
=COUNTIFS(E12:E45,"Shater",F12:F45,"Held")*25

This worked, thank you for the input!