COUNTIF formula

  • Thread starter Thread starter John Sullivan
  • Start date Start date
J

John Sullivan

I have 3 columns of data. Col 1 is either the number 1
(to indicate that the person lsited on that row has
signed up for volunteer work) or the number 2 (to
indicate has not signed up to work). In the next column,
each row has either the word "New Member Class"
or "Welcome Card." I'd like a formula that would count
the number of people who have signed up and who signed up
as a result of a new member class. I have the formula
=COUNTIF(G2:G34,"New Member Class") but need to know how
to add to the argument the number '1' or '2' to have the
function count only those people who are 1's or 2's
crosstabbed with "New Member Class". Thanks.
 
Hi John,

Use SUMPRODUCT instead:

=SUMPRODUCT((A1:A10={1,2})*(B1:B10="NEW MEMBER CLASS"))

Adjust ranges as needed.

Biff
 
-----Original Message-----
I have 3 columns of data. Col 1 is either the number 1
(to indicate that the person lsited on that row has
signed up for volunteer work) or the number 2 (to
indicate has not signed up to work). In the next column,
each row has either the word "New Member Class"
or "Welcome Card." I'd like a formula that would count
the number of people who have signed up and who signed up
as a result of a new member class. I have the formula
=COUNTIF(G2:G34,"New Member Class") but need to know how
to add to the argument the number '1' or '2' to have the
function count only those people who are 1's or 2's
crosstabbed with "New Member Class". Thanks.
.
Try adding a column to your worksheet with the conicate
Click to expand...
formula it combines text. combine column 1&2 the result
will be 1new member class or 2new mwnber class then count
if "new member class1"you can hide this column if you
don't want it to print or show. 1 new member class
1new member class
2 welcome card 2welcome card
2 welcome card 2welcome card
1 new member class 1new member class
1 new member class 1new member class
1 new member class 1new member class
2 new member class 2new member class
then count the new column and you are done good luck
 
If you only want to count the 1's use
=SUMPRODUCT((A1:A10=1)*(B1:B10="NEW MEMBER CLASS"))
 
Back
Top