Formula that looks at two columns

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

From: rsmith@xxxxxxxxxxx (Ralph Smith)
Date: Tue, 24 May 2005 20:09:37 GMT

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.
.

Follow-Ups:
- RE: Formula that looks at two columns
  - From: Duke Carey
- RE: Formula that looks at two columns
  - From: Peo Sjoblom
- Re: Formula that looks at two columns
  - From: JE McGimpsey

Prev by Date: Re: {} SumIf and CountIf
Next by Date: Re: Converting number of days to years and months
Previous by thread: {} SumIf and CountIf
Next by thread: Re: Formula that looks at two columns
Index(es):
- Date
- Thread

Relevant Pages

Text box & Circles Disappear
... circle or a square it disappears when I scroll down or change the zoom ... Prev by Date: ...
(microsoft.public.word.application.errors)
Re: how do I type around the edges of a triangle
... > How do I type around the edge of a triangle, circle or square? ... Prev by Date: ...
(microsoft.public.publisher)
Transferring background to object
... it into an object (square, circle, etc). ... George ... Prev by Date: ...
(microsoft.public.powerpoint)
how do I type around the edges of a triangle
... How do I type around the edge of a triangle, circle or square? ... Prev by Date: ...
(microsoft.public.publisher)
Re: Help a poor FORTRAN programmer with member functions?
... void* should be avoided, and is ... the base class for you other shapes. ... class Square: public Shape ... Circle to give their own version of Printthat does what they need it ...
(comp.lang.cpp)