| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how many perfect score
we use a score of 1 through 10 on our survey. i want to count how many
perfect 10's or in a range. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how many perfect score
Try this:
=COUNTIF(A1:A100,10) Adjust the range to suit. -- Biff Microsoft Excel MVP "James" wrote in message ... we use a score of 1 through 10 on our survey. i want to count how many perfect 10's or in a range. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how many perfect score
If the scores are in column A in A1 thru A100, then:
=COUNTIF(A1:A100,10) -- Gary''s Student - gsnu200793 "James" wrote: we use a score of 1 through 10 on our survey. i want to count how many perfect 10's or in a range. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how many perfect score
Hi,
If the range is A2:A200 =COUNTIF(A2:A200,10) Change range to suit your data. Regards - Dave. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to fit each cell into a perfect square? | Excel Discussion (Misc queries) | |||
| Making the perfect sort. | Excel Discussion (Misc queries) | |||
| Make a sheet to enter score and score is copy to the proper cell.. | Excel Worksheet Functions | |||
| searching for my perfect algorithm.... | Excel Discussion (Misc queries) | |||
| looking for my perfect algorithm | Excel Discussion (Misc queries) | |||
Linear Mode
