# If one column = Yes, sum previous column to cell

• Had a quick look around too see if i could find what i was looking for, but i couldn't so here i am!

First of all, thanks for you guys existing, because without you lot I'd be lost forever

I have a column (column D) that either has Yes or No written in it. Column C has a quantity in it. If D is Yes, i would like the quantity in C added... I'm guessing that this is probably a SUMPRODUCT equation?! relatively simple formula i'm guessing, but i'm useless!

Cheers

• Re: If one column = Yes, sum previous column to cell

heres your sumproduct. you just have to change the columns

=+SUMPRODUCT((A3:A7)*(B3:B7="Yes"))

have fun

## Files

• Re: If one column = Yes, sum previous column to cell

Thank you very much!! You're a gem

:ole:

• Re: If one column = Yes, sum previous column to cell

There's no need for SUMPRODUCT, a simple SUMIF would work here.

=SUMIF(B3:B7,"Yes",A3:A7)

Boo!:yikes:

• Re: If one column = Yes, sum previous column to cell

simple is always better. Thanks Norie

## Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!