need help creating a formula

Copper Contributor

I have a table of trading cards, that i'm trying to complete a set.

Column A - Card name

Column B- Price

C & D are other descriptors

Column E - do I own it or not

Column F  i need to reflect column B unless I indicate in column E that I own it, so that I can get a running total value from the sum of column F

 

1 Reply

@Bobby37073 

If column E contains TRUE/FALSE, enter the following formula in F2:

=IF(E2,"",B2)

If column E contains Yes/No:

=IF(E2="Yes","",B2)

 

Alternatively, you can sum the prices of the cards you don't own in one cell:

=SUMIF(E2:E100,FALSE,B2:B100)

or

=SUMIF(E2:E100,"No",B2:B100)

Adjust the ranges as needed.