Formula to add prices if YES or if NO - help

[elite-fusion]

Hello everyone,

I was just wondering if someone can help me out.

I have a spreadsheet with a few columns, Column E and F are the ones I need to work with.

Column E contains prices
Column F contains YES or NO

I would like to know what formula I should use in order for Excel to calculate all the prices for Column E, if Column F is a YES and also if it is a NO.

Please help me out guys.

[martindwilson]

=sumif(f1:f100,"yes",e1:e100)
=sumif(f1:f100,"no",e1:e100)

[elite-fusion]

Wow, that was much easier than i thought it would be.

I wish i knew excel a bit more LOL

Thank you very much martindwilson