countif statement
 

I AM TRYING TO COUNT THE NUMBER OF ROWS THAT TWO MEET DIFFERENT CRITERIA IN
TWO DIFFERENT COLUMNS.

IN THE EXAMPLE BELOW I WANT TO COUNT THE NUMBER OF ROWS DOG AND BROWN MATCH.
SO THE ANSWER IN THIS CASE WOULD BE 2

I TRIED USING "COUNTIF" "COUNTA", SEVERAL IF AND STATEMENTS. I NEED SOME
HELP.


A B C

DOG BROWN

CAT WHITE

MOUSE RED

DOG WHITE

DOG BROWN

CAT BROWN

countif statement
 

=sumproduct((a2:a22="dog")*(b2:b22="brown"))

--
Don Guillett
SalesAid Software

"italiavb" wrote in message
...
I AM TRYING TO COUNT THE NUMBER OF ROWS THAT TWO MEET DIFFERENT CRITERIA IN
TWO DIFFERENT COLUMNS.

IN THE EXAMPLE BELOW I WANT TO COUNT THE NUMBER OF ROWS DOG AND BROWN
MATCH. SO THE ANSWER IN THIS CASE WOULD BE 2

I TRIED USING "COUNTIF" "COUNTA", SEVERAL IF AND STATEMENTS. I NEED SOME
HELP.


A B C

DOG BROWN

CAT WHITE

MOUSE RED

DOG WHITE

DOG BROWN

CAT BROWN

countif statement
 

Thanks Don, it worked perfectly

Ciao

"Don Guillett" wrote in message
...
=sumproduct((a2:a22="dog")*(b2:b22="brown"))

--
Don Guillett
SalesAid Software

"italiavb" wrote in message
...
I AM TRYING TO COUNT THE NUMBER OF ROWS THAT TWO MEET DIFFERENT CRITERIA
IN TWO DIFFERENT COLUMNS.

IN THE EXAMPLE BELOW I WANT TO COUNT THE NUMBER OF ROWS DOG AND BROWN
MATCH. SO THE ANSWER IN THIS CASE WOULD BE 2

I TRIED USING "COUNTIF" "COUNTA", SEVERAL IF AND STATEMENTS. I NEED SOME
HELP.


A B C

DOG BROWN

CAT WHITE

MOUSE RED

DOG WHITE

DOG BROWN

CAT BROWN

countif statement
 

Don,
Can the wildcard symbol (*) be used in the formula?

"Don Guillett" wrote in message
...
=sumproduct((a2:a22="dog")*(b2:b22="brown"))

--
Don Guillett
SalesAid Software

"italiavb" wrote in message
...
I AM TRYING TO COUNT THE NUMBER OF ROWS THAT TWO MEET DIFFERENT CRITERIA
IN TWO DIFFERENT COLUMNS.

IN THE EXAMPLE BELOW I WANT TO COUNT THE NUMBER OF ROWS DOG AND BROWN
MATCH. SO THE ANSWER IN THIS CASE WOULD BE 2

I TRIED USING "COUNTIF" "COUNTA", SEVERAL IF AND STATEMENTS. I NEED SOME
HELP.


A B C

DOG BROWN

CAT WHITE

MOUSE RED

DOG WHITE

DOG BROWN

CAT BROWN

countif statement
 

Example of data

--
Don Guillett
SalesAid Software

"italiavb" wrote in message
...
Don,
Can the wildcard symbol (*) be used in the formula?

"Don Guillett" wrote in message
...
=sumproduct((a2:a22="dog")*(b2:b22="brown"))

--
Don Guillett
SalesAid Software

"italiavb" wrote in message
...
I AM TRYING TO COUNT THE NUMBER OF ROWS THAT TWO MEET DIFFERENT CRITERIA
IN TWO DIFFERENT COLUMNS.

IN THE EXAMPLE BELOW I WANT TO COUNT THE NUMBER OF ROWS DOG AND BROWN
MATCH. SO THE ANSWER IN THIS CASE WOULD BE 2

I TRIED USING "COUNTIF" "COUNTA", SEVERAL IF AND STATEMENTS. I NEED SOME
HELP.


A B C

DOG BROWN

CAT WHITE

MOUSE RED

DOG WHITE

DOG BROWN

CAT BROWN