Putting line between formula
For your first question:
=COUNTIF(C4:AJ4,"?*")&" - "&COUNTIF(C4:AJ4,"X*")
Also I can't seem to get this formula to add 20 instead its adding 1 only
=COUNTIF(C4:AJ4,"X*")
Not sure what that means? The result should be 20 but it's only returning 1?
Biff
"Killer" wrote in message
...
Hey there
Right now this formula reads both checkmarks and X's as one but I want it
to
show 1-1 instead
=COUNTIF(C4:AJ4,"?*")+COUNTIF(C4:AJ4,"X*")
Also I can't seem to get this formula to add 20 instead its adding 1 only
=COUNTIF(C4:AJ4,"X*")
|