| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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*") |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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*") |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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*") |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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*") |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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*") |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| putting in threshold line that easily depicts reaching a goal | Charts and Charting in Excel | |||
| putting 2 conditions in a formula | Excel Discussion (Misc queries) | |||
| formula for putting points into groups | Excel Worksheet Functions | |||
| how can i fix one entire column after putting my formula there so. | Excel Worksheet Functions | |||
| Putting numbers in excel without it changing into a formula? | Excel Worksheet Functions | |||
Linear Mode
