| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
countif from specific range
I am trying to count data which falls within a specific non-sequential range.
So i basically only want to count if the a1:a100 is equal to: 11,12,13,15,18,89,88,69,56, but i can't seem to find a way around it that doesn't error Would it help if i used a named range? Thanks in advance. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
countif from specific range
try this
=COUNTIF(A1:A100,11)+COUNTIF(A1:A100,12)+COUNTIF(A 1:A100,13)+COUNTIF(A1:A100,15)+COUNTIF(A1:A100,18) +COUNTIF(A1:A100,88)+COUNTIF(A1:A100,89)+COUNTIF(A 1:A100,69)+COUNTIF(A1:A100,156) "shakey1181" wrote: I am trying to count data which falls within a specific non-sequential range. So i basically only want to count if the a1:a100 is equal to: 11,12,13,15,18,89,88,69,56, but i can't seem to find a way around it that doesn't error Would it help if i used a named range? Thanks in advance. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
countif from specific range
Maybe one way:
=SUMPRODUCT(--(A1:A100={11,12,13,15,18,89,88,69,56})) HTH, Paul "shakey1181" wrote in message ... I am trying to count data which falls within a specific non-sequential range. So i basically only want to count if the a1:a100 is equal to: 11,12,13,15,18,89,88,69,56, but i can't seem to find a way around it that doesn't error Would it help if i used a named range? Thanks in advance. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
countif from specific range
Try
=SUM(COUNTIF(A1:A100,{11;12;13;15;18;56;89;88;69}) ) -- Regards, Peo Sjoblom "shakey1181" wrote in message ... I am trying to count data which falls within a specific non-sequential range. So i basically only want to count if the a1:a100 is equal to: 11,12,13,15,18,89,88,69,56, but i can't seem to find a way around it that doesn't error Would it help if i used a named range? Thanks in advance. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count Specific word in specific range | Excel Worksheet Functions | |||
| Count If Specific word in specific range | Excel Discussion (Misc queries) | |||
| MEDIAN, STDEV of a range IF another range = specific value | Excel Worksheet Functions | |||
| countif >0, specific cells | Excel Worksheet Functions | |||
| Countif for specific cells rather than a range ???? | Excel Worksheet Functions | |||
Linear Mode
