Conditional adding

[spelbound]

Hello everyone. First post so please be gentle. I'm a relative newb to excel and am looking how to apply a conditional addition. By that I mean it only adds the number in G2 if the text in A2 says "Yes" and ignores it if any other text e.g. "no". I need this rule to apply to multiple rows and the answer to appear at the bottom of a column...for arguments sake lets say G15.

I hope that makes sense. I can provide the workbook or a screenshot if necessary.

Thanks in advance.

[Pete_UK]

Try this in G15:

=SUMIF(A2:A14,"yes",G2:G14)

Hope this helps.

Pete

[gcai.reportsanalyst]

Let's assume you want to add G2 to H2 if A2 is yes, and return the value of H2 as is if otherwise.
=if(A2="Yes",G2+H2,H2)

[Kevin#]

Deleted - I got it wrong

[spelbound]

Well I replied in the wrong place and can't delete it lol

[spelbound]

Try this in G15:

=SUMIF(A2:A14,"yes",G2:G14)

Hope this helps.

Pete

That's awesome. Works exactly how I wanted. Now, instead of Yes/No drop down list I've decided to just use check boxes. I've added them and linked them to the cells they sit in, but how do I adjust the above formula to sumif the presence of a tick instead of "yes". Thanks again.

[Kevin#]

Alternative to using checkboxes,
- format the cells with font Marlett, and then enter "a" in the cell - it displays a tick ("r" and it displays an "X")
- it makes it easier if you want to use it elsewhere as a condition or in macros

see attached and look at the formula in columns D & E