Forum Discussion
need help creating a formula
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
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.
