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

**Jeniji** · 07-28-2020, 07:45 PM

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.

**ORoos** · 07-28-2020, 09:00 PM

Try in cell D1 (then pull down):

Formula:

Please Login or Register  to view this content.

**protonLeah** · 07-28-2020, 10:14 PM

#2 modified:

Please Login or Register  to view this content.

**boopathiraja** · 07-29-2020, 07:46 AM

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

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

LinkBack

Thread Tools

Rate This Thread

Display

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

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

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

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

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions