Hi,

You may try the following array formula (Ctrl+Shift+Enter)

=sum(if((range=specific category )*(range2=specific type),1,0))

Regards,

"Omakbob" wrote:

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.