About Us

Don Guillett

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

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
COUNTIF statement with 3 criteria checks	Malvaro	Excel Discussion (Misc queries)	4	June 4th 06 11:40 PM
Countif Statement	souchie40	Excel Discussion (Misc queries)	3	May 4th 06 05:42 PM
Can criteria in countif statement be a color?	aosbor	Excel Worksheet Functions	1	November 23rd 05 09:17 PM
Adding an AND Statement to COUNTIF	Kenton_SJ	Excel Worksheet Functions	2	June 17th 05 11:59 PM
countif statement	Russell Hampton	Excel Worksheet Functions	6	December 18th 04 07:39 PM