Thread
:
countif statement
View Single Post
#
3
Posted to microsoft.public.excel.worksheet.functions
italiavb
external usenet poster
Posts: 19
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
Reply With Quote
italiavb
View Public Profile
Find all posts by italiavb