With some of your help I built a spreadsheet that tallies wins in a game, that populates a cell with a win count. Works great. See below.
=COUNTIF(A1:A10,"w")
I'd like to add more functionality since when no one wins the cells are blank.
My goal is to have the column report a '0' if there are no wins, rather than show a blank cell and this simple formula can only count 'w' and provide a total.
Suggestions anyone?
Thanks very much in advance.
=COUNTIF(A1:A10,"w")
I'd like to add more functionality since when no one wins the cells are blank.
My goal is to have the column report a '0' if there are no wins, rather than show a blank cell and this simple formula can only count 'w' and provide a total.
Suggestions anyone?
Thanks very much in advance.