Hi Shane,

Thanks a lot. Your script for the Excel 2003 did the magic for me. I still
have two more questions for you and others please,

1. How can I select two items on my dropdown menu created using the data
validation method in Excel 2003? Presently I can only select one item, but I
will like to be able to select two items at a time.

2. How can I make calendar to pupup so as to be able to select month/date
please?

3. Is it possible to write a script to reject a name that already features
among my client list in an excel sheet: Please give me some clues or the
script for it.

Cheers,
Dolpan


Shane Devenshire wrote:
Hi,

1. Enter the value (mark) you want in D1
2. Use the formula
=COUNTIF(B1:B20,D1)

If you want just males or just females with a particular score, in 2007 you
could use
=COUNTIFS(B1:B20,D1,A1:A20,E1)
where E1 contains the number 1 or 2 to indicate male or female and D1 is as
above.

If you want to count both males and females with scores between 40% and 50%
for example
2007:
=COUNTIFS(B1:B20,D1,B1:B20,E1)
with =.4 in D1 and <=.5 in E1
2003
=SUMPRODUCT((B1:B20=D1)*(B1:B20<=E1))
with .4 in D1 and .5 in E1

I have two columns in an excel sheet. One column shows 1 representing male
and 2 represnting female. In the second column I have marks scored by males
[quoted text clipped - 8 lines]
Dolpandotcom
06/16/09

--
Message posted via http://www.officekb.com