I need to create a formula that checks to see that the text in 2 different
cells are supposed to be what the formula specifies before it calculates the
sum of 2 other cells
ie..
cell A1 = "Last"
cell B1 = "First"
cell C1 = "25"
cell D1 = "75"

The formula needs to be sure that cells a1 and b1 contain those exact words
otherwise it will give a response of "0"....but if they do contain those
exact words than the response would be the sum of cells c1 and d1....."100"

How do I write this formula correctly?