View Single Post
  #1   Report Post  
Ralph Smith
 
Posts: n/a
Default Formula that looks at two columns

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.