Putting line between formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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*")
 
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*")
Click to expand...

Not sure what that means? The result should be 20 but it's only returning 1?

Biff
 
Yes it's only returning 1 I need it to retrun 20

T. Valko said:
For your first question:

=COUNTIF(C4:AJ4,"?*")&" - "&COUNTIF(C4:AJ4,"X*")


Not sure what that means? The result should be 20 but it's only returning 1?

Biff
Click to expand...
 
Back
Top