Putting line between formula

K

Killer

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

T. Valko

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
 
K

Killer

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding network days 2
Excel Countif Function - Calculating Between Two Sets of Values 3
automating use of complicated formula 4
Kinda like a database - I can’t believe others don’t need to do th 3
External Data Warning Message - I have No External Data in wrkbk 0
SUMPRODUCT 5
Formula Result 17
Automatically changing link. How? 2

Top