Putting line between formula
You're welcome!
Biff
"Killer" wrote in message
...
Nevrmind I figured it out
thanks Biff
"Killer" wrote:
Yes it's only returning 1 I need it to retrun 20
"T. Valko" wrote:
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*")
|