Sum cells that meet certain criteria

[Brendansull]

Hi,
I am looking for a formula to sum the value of cells from B2 to B10, but only the cells that meet a specific condition, i.e. C2 to C10 having a Yes value.
So for example below

5




I have tried the countif and sumif, but can't seem to get them right.
Sorry I am only a new user to excel!

What I am trying is wrong as i either get 0 or invalid

 

[Brendansull]

Aplogise, I hit the enter kit by accident:
Hi,
I am looking for a formula to sum the value of cells from B2 to B10, but only the cells that meet a specific condition, i.e. C2 to C10 having a Yes value.
So for example below

5 yes
2 no
4 yes
Total: 9


Totally apologise, hit the enter key by accident!


I have tried the countif and sumif, but can't seem to get them right.
Sorry I am only a new user to excel!

What I am trying is wrong as i either get 0 or invalid

 

[mhighland]

Aplogise, I hit the enter kit by accident:
Hi,
I am looking for a formula to sum the value of cells from B2 to B10, but only the cells that meet a specific condition, i.e. C2 to C10 having a Yes value.
So for example below

5 yes
2 no
4 yes
Total: 9


Totally apologise, hit the enter key by accident!


I have tried the countif and sumif, but can't seem to get them right.
Sorry I am only a new user to excel!

What I am trying is wrong as i either get 0 or invalid

Try this: =SUMIF(C2:C10,"Yes",B2:B10)

 

[Brendansull]

MHighland,
Thank you very much. You have no idea how much time I spent on that. And now looking at it....it makes complete sense