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 col...
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.