Need more than COUNTIF function, I think..

[sunstarer]

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.

 

[Fluff]

If you are using the formula from post#19, then you will have a 0 in AK3.
If none is visible goto file , option, advanced, scroll down to Display options for this worksheet & check the box marked Show a zero in cells..., Ok

 

[sunstarer]

I plugged in the formula in AK3 and yes, the show zeros was unchecked, but checking it on still shows a blank. It also shows a blank in the example provided rather than a zero. Am I missing something, again : ).

 

[Fluff]

When you get to the display options for this worksheet make sure you have the correct sheet selected in the drop down.
If that still does not show a zero, make sure you have no conditional formatting hidding zeros

 

[Michael M]

Change to format options for col "AK"
File>>Options>>Advanced>>Display Options for this worksheet>>Check the box that says "Show a zero for cells that have a zero value"

 

[sunstarer]

I checked all of these settings and still no zero. What puzzles me is that in Michael M's example there is no zero there either despite having the new formula in place. Hmm...

 

[Fluff]

Got it, you have a custom number format set that hides zeros, change the format for those columns to General.

 

[sunstarer]

BINGO! Thank you so much! To everyone.

 

[Fluff]

Glad we could help & thanks for the feedback.