Count text cells based on two criteria

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

aet999 - 15 Mar 2006 17:01 GMT

I have a spreadsheet with many columns. I would like to count how many
occurances there are of two criteria matching. Example, If column A contains
names of girls (amy, betty, susie, karen, betty) and column B contains names
of boys (michael, robert, andrew, james, joseph). how many times does column
A = betty AND column b = robert on the same row? In this example, the answer
would be one.

Reply to this Message

Tom Ogilvy - 15 Mar 2006 17:16 GMT

=Sumproduct(--(A1:A100="betty"),--(B1:B100="robert"))

--
Regards,
Tom Ogilvy

> I have a spreadsheet with many columns. I would like to count how many
> occurances there are of two criteria matching. Example, If column A contains
> names of girls (amy, betty, susie, karen, betty) and column B contains names
> of boys (michael, robert, andrew, james, joseph). how many times does column
> A = betty AND column b = robert on the same row? In this example, the answer
> would be one.

Reply to this Message

aet999 - 15 Mar 2006 17:36 GMT

It worked. Thanks. You rock!

> =Sumproduct(--(A1:A100="betty"),--(B1:B100="robert"))
>
[quoted text clipped - 8 lines]
> > A = betty AND column b = robert on the same row? In this example, the answer
> > would be one.

Reply to this Message