Well, that worked for one of the colums, but the others gave me a "0". I'll
keep trying....

thanks

"Alan" wrote:

Witth the category in column A
The type in column B.
The number of people in column C
Try
=SUMPRODUCT(--(A1:A500=1046),--(B1:B500="Med"),--(C1:C100))
Adjust to suit, note that the search criteria can be in a cell, like instead
of (B1:B500="Med") you can use (B1:B500=G1) where G! contains Med,
Regards,
Alan.

"Omakbob" wrote in message
...
I cannot figure it out for the life of me.
I have a table with 3 colums:
1) Category of plan (i.e. 1046, 1046-1)
2) Type of plan (med, dent, life)
3) Number of people in that plan.

What I need is a formula that will sum the total number of people in a
particular plan. Example: The sum of all people who are in a 1046 group
and
are dental subscibers.

Any help would be appreciated.