I'm working through a number of tasks on Excel training, and one of them is based on a sports club's membership database.

It asks you to count the number of female members who are also gold members (as opposed to silver, bronze).

The question tells you to use COUNTA specifically for the task, though every website i've consulted says that COUNTA is not used to count multiple criteria like this, and I thought I should be using COUNTIF instead?

Is the question right in telling me to use COUNTA?

Certainly not COUNTA and COUNTIF would not be my choice.

SUMPRODUCT would do the job.

M or F in Column A

G, S or B Column B

=SUMPRODUCT((A1:A43="F")*(B1:B43="G"))



Gord


On Thu, 12 Jan 2012 22:02:23 +0000, Asystole
wrote:


I'm working through a number of tasks on Excel training, and one of them
is based on a sports club's membership database.

It asks you to count the number of female members who are also gold
members (as opposed to silver, bronze).

The question tells you to use COUNTA specifically for the task, though
every website i've consulted says that COUNTA is not used to count
multiple criteria like this, and I thought I should be using COUNTIF
instead?

Is the question right in telling me to use COUNTA?