COUNTA for counting numerous text entries?

A

Asystole

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

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

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

Is the question right in telling me to use COUNTA
 
G

Gord Dibben

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

COUNTIF formula multiple text exclusions 4
VBA Macro Training in Chennai 0
IF COUNTIF & COUNTA on Filtered Visible Cells 0
count data entries using a criteria 3
Comparing & Counting Data 0
Summarising/Counting variable data 1
What am I doing wrong tracking progress? 2
Problems Loading Large String Array into Array variable 6

Top