Putting line between formula
 

Hey there

Right now this formula reads both checkmarks and Xs as one but I want it to
show 1-1 instead
=COUNTIF(C4:AJ4,"ˆš*")+COUNTIF(C4:AJ4,"X*")

Also I cant seem to get this formula to add 20 instead its adding 1 only
=COUNTIF(C4:AJ4,"X*")

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*")

Putting line between formula
 

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*")

Putting line between formula
 

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*")

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*")