Formula that looks at two columns

Tech-Archive recommends: Speed Up your PC by fixing your registry



I am trying to determine how many times my colors are associated with
the objects --

Colors Objects

Red Square
Red Circle
Red Square
Yellow Oval
Yellow Star
Yellow Star
Blue Star
Blue Square
Blue Square

For instance, I would like to know how many times Red and Square show
up and how many times Red and Circle show up. Is there a forumula
that will take a look at both columns.

Thanks.
.



Relevant Pages