Great place for a pivot table. Select all the data, including the "Colors"
and "Objects" column headers and use DataPivot Table. Just click on the
Finish button and then drag one field into the row area, the other field into
the column area, and either field into the data area. That's all there is to
it

"Ralph Smith" wrote:

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.