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) |