Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have a column of numbers (0-10) and i need to count the number of 7's and
8's in the column. I can manage to count one number i.e all 9's etc but not sure how to do a range. Any ideas welcom |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
=countif(a:a,7)+countif(a:a,8)
or =sum(countif(a:a,{7,8})) AK241 wrote: I have a column of numbers (0-10) and i need to count the number of 7's and 8's in the column. I can manage to count one number i.e all 9's etc but not sure how to do a range. Any ideas welcom -- Dave Peterson |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Thank you
"Dave Peterson" wrote: =countif(a:a,7)+countif(a:a,8) or =sum(countif(a:a,{7,8})) AK241 wrote: I have a column of numbers (0-10) and i need to count the number of 7's and 8's in the column. I can manage to count one number i.e all 9's etc but not sure how to do a range. Any ideas welcom -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
COUNTIF | Excel Discussion (Misc queries) | |||
How do I use a countif function according to two other countif fu. | Excel Worksheet Functions | |||
edit this =COUNTIF(A1:F16,"*1-2*")+COUNTIF(A1:F16,"*2-1*") | Excel Discussion (Misc queries) | |||
COUNTIF or not to COUNTIF on a range in another sheet | Excel Worksheet Functions | |||
COUNTIF in one colum then COUNTIF in another...??? | Excel Worksheet Functions |