I would suggest creating a pivot table report for this. Make Category and
Type row fields and make Number of People the value field.

Select a cell in the data range and then follow the menu path Data / Pivot
Table & Pivot Chart Report and follow the wizard's instructions. Excel help
is pretty good with this as well for a simple table like your issue.

Hope this helps.

Bill Horton

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