Formula which counts numbers except if the line has a (specific word)

Hi All,

How are you doing,

I'm making a basic spreadsheet for work. Need some assistance on counting revenue. However want the total revenue to not count it if (the word -"lost" ) is embedded in the cell.

Can you advise what formula I should use. I tried Sumif, countif and can't seem to get a proper line to work it out.

So as you can see for Cell I9, the code should reflect the BDMS's count of revenue, but not count if cell G17 states lost.

Can anyone assist?

Thank you