Thread: Counting words
View Single Post
  #1   Report Post  
johanl
 
Posts: n/a
Default Counting words


I have two columns.

The first one with four diffrent words (cat, dog, rabbit, fish, horse
and bird), and the second column have nine different names.

The worsheet works so that the first column shows what pet the owner
(In the second column) has . It´s a pretty long list...

I want to make a function that only counts when the first column says
"cat" and the second says"Pet Owner 1".

Hope someone understand what I´m rambling about... :)


--
johanl
------------------------------------------------------------------------
johanl's Profile: http://www.excelforum.com/member.php...o&userid=25740
View this thread: http://www.excelforum.com/showthread...hreadid=391512