Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
=COUNTIF(D4:D29,"0")
I need this formula to also count negative numbers
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
=COUNTIF(D4:D29,"0")
Have you tried this:
=COUNTIF(D4:D29,"<0") -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "Mike" wrote in message ... I need this formula to also count negative numbers |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
=COUNTIF(D4:D29,"0")
I need this do count both negative and positive
"RagDyeR" wrote: Have you tried this: =COUNTIF(D4:D29,"<0") -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "Mike" wrote in message ... I need this formula to also count negative numbers |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
=COUNTIF(D4:D29,"0")
I need them to by 1 EXample
1 2 4 5 10 11 15 16 -19 24 0 -13 0 2 0 -9 0 0 0 0 0 -3 0 1 0 -46 1 - 0 0 -11 0 -120 0 0 0 5 -1 1 0 Total 4 2 3 3 4 3 4 "Mike" wrote: I need this do count both negative and positive "RagDyeR" wrote: Have you tried this: =COUNTIF(D4:D29,"<0") -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "Mike" wrote in message ... I need this formula to also count negative numbers |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
=COUNTIF(D4:D29,"0")
=SUM(D4:D29)
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Mike" wrote in message ... I need them to by 1 EXample 1 2 4 5 10 11 15 16 -19 24 0 -13 0 2 0 -9 0 0 0 0 0 -3 0 1 0 -46 1 - 0 0 -11 0 -120 0 0 0 5 -1 1 0 Total 4 2 3 3 4 3 4 "Mike" wrote: I need this do count both negative and positive "RagDyeR" wrote: Have you tried this: =COUNTIF(D4:D29,"<0") -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "Mike" wrote in message ... I need this formula to also count negative numbers |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
=COUNTIF(D4:D29,"0")
I guess i need to have THE ABS value
"RagDyeR" wrote: Have you tried this: =COUNTIF(D4:D29,"<0") -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "Mike" wrote in message ... I need this formula to also count negative numbers |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
=COUNTIF(D4:D29,"0")
Maybe...
=COUNTIF(D4:D29,"<0") Mike wrote: I need this formula to also count negative numbers -- Dave Peterson |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
=COUNTIF(D4:D29,"0")
=COUNTIF(D4:D29,"<0") will count anything not zero (empty cells, text,
booleans, errors, etc). It also behaves strangely on sheets where the last row ever used is <29. To count only positive or negative numbers, use =COUNTIF(D4:D29,"0")+COUNTIF(D4:D29,"<0") Jerry "Dave Peterson" wrote: Maybe... =COUNTIF(D4:D29,"<0") Mike wrote: I need this formula to also count negative numbers -- Dave Peterson |
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
=COUNTIF(D4:D29,"0")
Good point.
Another alternative... =COUNT(D4:D29)-COUNTIF(D4:D29,0) Which will distiguish between text 0 ('0) and the number 0. Jerry W. Lewis wrote: =COUNTIF(D4:D29,"<0") will count anything not zero (empty cells, text, booleans, errors, etc). It also behaves strangely on sheets where the last row ever used is <29. To count only positive or negative numbers, use =COUNTIF(D4:D29,"0")+COUNTIF(D4:D29,"<0") Jerry "Dave Peterson" wrote: Maybe... =COUNTIF(D4:D29,"<0") Mike wrote: I need this formula to also count negative numbers -- Dave Peterson -- Dave Peterson |
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
=COUNTIF(D4:D29,"0")
TY Very Much That Worked Great
"Dave Peterson" wrote: Good point. Another alternative... =COUNT(D4:D29)-COUNTIF(D4:D29,0) Which will distiguish between text 0 ('0) and the number 0. Jerry W. Lewis wrote: =COUNTIF(D4:D29,"<0") will count anything not zero (empty cells, text, booleans, errors, etc). It also behaves strangely on sheets where the last row ever used is <29. To count only positive or negative numbers, use =COUNTIF(D4:D29,"0")+COUNTIF(D4:D29,"<0") Jerry "Dave Peterson" wrote: Maybe... =COUNTIF(D4:D29,"<0") Mike wrote: I need this formula to also count negative numbers -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|