I have a cell (games played) that adds 3 variables (wins, loses, and draws), and doesn't display anything when they have no value.
=IF(D5+D6+D7 = 0, "", D5+D6+D7)
My variable wins (and the others when I add code them) detect when the word Wins appears in the same column as it. It also doesn't display anything when it has no value.
=IF(SUM(COUNTIF(D10:D29, "*Win*")) > 0, SUM(COUNTIF(D10:D29, "*Win*")), IF(D8 > 0, 0, ""))
I want it to display a 0 only when games played is more than 0 (so I don't have a bunch of zeros on the sheet) After making it display a 0 when games played is more than 0, it started giving me Circular Dependency Error. How can I fix this?
Here's a link to my file: Sample sheet
Best Answer
cell D5:
cell D11:
Circular Dependency Error was generated, because cell D11 was returning FALSE