Count cells only if Countifs condition met

Hi, first time poster.

I want to total the numeric sum of cells only if they meet the condition of cells in two other columns. I.E. column 1 has a numeric value, columns 2 and 3 have a Yes/No value. So, if column 2 is Yes and Column 3 is No, I want the cell in Column 1 to be included in the total.

I appreciate any advice.

A sample would make life easier. See the yellow banner. It is not clear if you just want 2 to be yes and 3 to be no, or any combinations of both are required

sumifs(a:a,b:b,"yes",c:c,"no")

Thank you for that quick response. Yes, I only wanted to include the numeric value if 2 was yes and 3 was no. I was looking at sumifs, but just couldn’t work out the Correct formula.