Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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*") |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |