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

Participate now!

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