need help creating a formula

Occasional Visitor

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


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


If column E contains Yes/No:



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




Adjust the ranges as needed.