Database

[Sophie Mann]

Hi there,

I have set up a very basic database and am having trouble
with one thing.

There are multiple columns with personal information in
them.

Two columns are Sex and Shortlist. The sex column have M
or F entered into them and Shortlist is a simple Yes or No.

I am trying to count the number of Shortlisted Males and
Females. ie. How many Males (or Females)have a Yes in the
Shortlist Column.

Thanks
S

 

[Chip Pearson]

Sophie,

Use a formula like the following:

=SUMPRODUCT((A1:A10="M")*(B1:B10="Yes"))

where A1:A10 contains "M" or "F" and B1:B10 contains "Yes" or
"No". Adjust your ranges accordingly.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com