=SUMIF Google Spreadsheet Help needed -

i new spreadsheets , need help.

i created sheet register money reimbursed.

what want is:

a) total shows total amount in column 'c' subtract row value if/when column 'e' says yes.

b) total should on display time in merged cells on 'f'.

i using this:

=sumif(e2:e9; "yes"; b2:b9) 

but think way off.

any kind of welcome.

spreadsheet reference: link here

does formula work want:

=sumif(e:e;"no";c:c)