sum if cells have yes, ignore if no

**ryanwalton** · 04-23-2010, 09:24 AM

Hi.. sorry very newbie question.. I have a spreadsheet with a range of monetry values in column a, and yes/no in column b next to it...

I need to work out how to sum just the yes values.

thanks in anticipation

Ryan

**sweep** · 04-23-2010, 09:30 AM

Hi,

You could use the SUMIF function.

=SUMIF(B1:B100,"Yes",A1:A100)

Adjust ranges to suit your data.

**Excel-o-ratoR** · 04-23-2010, 09:32 AM

Hi Ryan,

Please use the below formula -

=SUMIF(B1:B100,"Yes",A1:A100).

Hope it helps.

Cheers !!
Excel-o-ratoR

**ryanwalton** · 04-23-2010, 09:38 AM

thanks very much.. perfect for what i need.

Cheers +1 rep

sum if cells have yes, ignore if no

LinkBack

Thread Tools

Rate This Thread

Display

sum if cells have yes, ignore if no

Re: sum if cells have yes, ignore if no

Re: sum if cells have yes, ignore if no

Re: sum if cells have yes, ignore if no

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions