I'm trying to develop a counting formula that will need to look at one column
and count the second based on what's in the first and put the results in
another column all together. And it will need to include a range. For
example:

Column A = Employee's Age
Column B = Optional Life Insur (either will have a 0 for none or a 1 for 1x
base salary or a 2 for 2x base salary)

I need it to count how many people elected optional life insurance (from
Column B) by age groups (ie: ages 0-29, 30-39, 40-45, 46-49, etc). Put
results in a summary table in another section of the spreadsheet.

Any thoughts?
--
Robin W