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!