Remember Me?

#1
June 23rd 08, 05:45 PM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Jul 2006 Posts: 542
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
June 23rd 08, 05:51 PM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Nov 2006 Posts: 15,768
how many perfect score

Try this:

=COUNTIF(A1:A100,10)

--
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
June 23rd 08, 05:53 PM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Jul 2006 Posts: 11,058
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
June 23rd 08, 06:00 PM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Jul 2006 Posts: 1,388
how many perfect score

Hi,
If the range is A2:A200
=COUNTIF(A2:A200,10)
Change range to suit your data.
Regards - Dave.

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Eric Excel Discussion (Misc queries) 3 September 21st 07 07:15 AM HoganD87 Excel Discussion (Misc queries) 1 September 11th 07 11:14 PM Yan Excel Worksheet Functions 0 June 8th 07 02:41 PM meesh7391 Excel Discussion (Misc queries) 0 January 11th 06 01:55 PM meesh7391 Excel Discussion (Misc queries) 0 January 11th 06 12:06 AM

All times are GMT +1. The time now is 11:16 PM.