Total money owed to someone - formula needed

Whenever I order things off the internet, I need to pay my dad back afterwards (its his card...). Anyway, the problem is I seem to lost track of how much I owe him sometimes, so I made a spreadsheet with all the items I've ordered and their price. Also, there's a column (either 'y' or 'n') for whether I have paid him back. What I need is a cell that gives me the sum of the prices of all the items that I have not paid him back for. Rephrased, sum of items not marked with 'n' in another column. Thanks in advance.

Say your prices are in column B and the Y or N in column C,

=SUMIF(C1:C100,"N",B1:B100)

HTH

Steve

I completely forgot about SUMIF ! That's probably the most simple formula anyone's ever posted as an answer on here haha.... Thanks anyway (worked a treat by the way)

Glad to help.

Cheers,

Steve