Home |
Search |
Today's Posts |
#1
|
|||
|
|||
COUNTIF
COUNTIF seems to require a continuous range of cells to be inserted in the
formula. I have a series of discontinuous cells from which I wish to count all those that have the value 1. COUNTIF((A1,C3,D5),1) for example returns #VALUE#. Using colons as separators does not work either. Any suggestions? |
#2
|
|||
|
|||
I tried the formula as a range and it worked. The formula I used was:
=COUNTIF(A1:D5,1) Hope this helps, Les "nsharpe" wrote: COUNTIF seems to require a continuous range of cells to be inserted in the formula. I have a series of discontinuous cells from which I wish to count all those that have the value 1. COUNTIF((A1,C3,D5),1) for example returns #VALUE#. Using colons as separators does not work either. Any suggestions? |
#3
|
|||
|
|||
One way:
=(A1=1)+(C3=1)+(D5=1) In article , "nsharpe" wrote: COUNTIF seems to require a continuous range of cells to be inserted in the formula. I have a series of discontinuous cells from which I wish to count all those that have the value 1. COUNTIF((A1,C3,D5),1) for example returns #VALUE#. Using colons as separators does not work either. Any suggestions? |
#4
|
|||
|
|||
Maybe....
Insert/Name/Define =A1,C3,D5 as RangeTest for example and then: =COUNTIF(RangeTest,1) Does it help? -- A+ V. "nsharpe" wrote: COUNTIF seems to require a continuous range of cells to be inserted in the formula. I have a series of discontinuous cells from which I wish to count all those that have the value 1. COUNTIF((A1,C3,D5),1) for example returns #VALUE#. Using colons as separators does not work either. Any suggestions? |
#5
|
|||
|
|||
Brute force.......
=SUM(COUNTIF(A1,1),COUNTIF(C3,1),COUNTIF(D5,1)) Vaya con Dios, Chuck, CABGx3 "nsharpe" wrote: COUNTIF seems to require a continuous range of cells to be inserted in the formula. I have a series of discontinuous cells from which I wish to count all those that have the value 1. COUNTIF((A1,C3,D5),1) for example returns #VALUE#. Using colons as separators does not work either. Any suggestions? |
#6
|
|||
|
|||
forget it....
-- A+ V. "Vincnet." wrote: Maybe.... Insert/Name/Define =A1,C3,D5 as RangeTest for example and then: =COUNTIF(RangeTest,1) Does it help? -- A+ V. "nsharpe" wrote: COUNTIF seems to require a continuous range of cells to be inserted in the formula. I have a series of discontinuous cells from which I wish to count all those that have the value 1. COUNTIF((A1,C3,D5),1) for example returns #VALUE#. Using colons as separators does not work either. Any suggestions? |
#7
|
|||
|
|||
In article ,
"Vincnet." wrote: Maybe.... Insert/Name/Define =A1,C3,D5 as RangeTest for example and then: =COUNTIF(RangeTest,1) Does it help? Did you try it yourself? |
#8
|
|||
|
|||
I don't say that it is a good solution but try:
=SUM(COUNTIF(INDIRECT({"A1","C3","D5"}),1)) -- HTH Sandy Replace@mailinator with @tiscali.co.uk "nsharpe" wrote in message ... COUNTIF seems to require a continuous range of cells to be inserted in the formula. I have a series of discontinuous cells from which I wish to count all those that have the value 1. COUNTIF((A1,C3,D5),1) for example returns #VALUE#. Using colons as separators does not work either. Any suggestions? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
COUNTIF COMBINATION?? | Excel Worksheet Functions | |||
Combining IF and COUNTIF based on two columns | Excel Discussion (Misc queries) | |||
COUNTIF in one colum then COUNTIF in another...??? | Excel Worksheet Functions | |||
Countif - Countif | Excel Worksheet Functions | |||
countif, again | Excel Worksheet Functions |