| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
COUNT OR COUNTIF for this?
I have up to 7 time-formatted data in between c3-p3.
I want to count all valuies except those showing as "00:00", then divide the result by 2. Should I do this with COUNT or COUNTIF and if so, what would be the form of the expression? Many thanks for your help. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
COUNT OR COUNTIF for this?
I guess =COUNTIF(C3:P3;"<0:00") should do the trick.
Greets, Gunti "Zakynthos" wrote: I have up to 7 time-formatted data in between c3-p3. I want to count all valuies except those showing as "00:00", then divide the result by 2. Should I do this with COUNT or COUNTIF and if so, what would be the form of the expression? Many thanks for your help. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
COUNT OR COUNTIF for this?
Dividing this by 2 is obviously =((Countif(C3:P3;"<0:00")/2)
"Gunti" wrote: I guess =COUNTIF(C3:P3;"<0:00") should do the trick. Greets, Gunti "Zakynthos" wrote: I have up to 7 time-formatted data in between c3-p3. I want to count all valuies except those showing as "00:00", then divide the result by 2. Should I do this with COUNT or COUNTIF and if so, what would be the form of the expression? Many thanks for your help. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
COUNT OR COUNTIF for this?
Gunti,
Much appreciated - worked perfectly! "Gunti" wrote: Dividing this by 2 is obviously =((Countif(C3:P3;"<0:00")/2) "Gunti" wrote: I guess =COUNTIF(C3:P3;"<0:00") should do the trick. Greets, Gunti "Zakynthos" wrote: I have up to 7 time-formatted data in between c3-p3. I want to count all valuies except those showing as "00:00", then divide the result by 2. Should I do this with COUNT or COUNTIF and if so, what would be the form of the expression? Many thanks for your help. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| COUNTIF or COUNT.... IF | Excel Worksheet Functions | |||
| Please help with Count or Countif... | Excel Discussion (Misc queries) | |||
| how can I count (countif) the character: * | Excel Worksheet Functions | |||
| count many with COUNTIF? | Excel Worksheet Functions | |||
| Count, Countif, Sumif?? | Excel Worksheet Functions | |||
Linear Mode
