counting cells with a dash
counting cells with a dash
I seem to be stuck on using a wildcard character. Across a range I want to count how many instances of the dash "-" character. I tried this and it does not work:
=COUNTIF(
B4:R6
;
"*-*"
)
Can someone help me with this one? Thanks, Jeff