If B1=Yes then add A1 to C1. B2=Yes the add A2 to C1 (And so on)

1. If B1=Yes then add A1 to C1. B2=Yes the add A2 to C1 (And so on)

I am looking for a formula that I can take the "Payment" amount from A column, and add them to a single cell on, for example, C1. But the amount from each cell on A1 can only be added to C1 if the corresponding cell in column B says Yes. if it says No, then the amount in the corresponding A column is not added to C1.

2. Re: If B1=Yes then add A1 to C1. B2=Yes the add A2 to C1 (And so on)

Try in cell D1 (then pull down):
Formula:
`Please Login or Register  to view this content.`

3. Re: If B1=Yes then add A1 to C1. B2=Yes the add A2 to C1 (And so on)

#2 modified:
``Please Login or Register  to view this content.``

4. Re: If B1=Yes then add A1 to C1. B2=Yes the add A2 to C1 (And so on)

Hi, C1 =SUMIFS(\$A\$1:A1,\$B\$1:B1,"Yes") and drag it down..

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1