Sum if condition found in 2 columns

[The Animal]

Hi
I assume I need a Count and/or Sum formula if the letter "S" is found in "I4" and also "A" is found in "F4" (both found not if/or) then use value found in "AP4"
Any help would be great
Stephen

 

[Joe4]

Take a look at SUMIFS and COUNTIFS, which allow you to have multiple conditions.

See:
https://www.techonthenet.com/excel/formulas/countifs.php
https://www.techonthenet.com/excel/formulas/sumifs.php