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

You would need to adjust the ranges and the values in this formula to get the
results you want:

=SUMPRODUCT(--(A3:A6<30),--(A3:A625),--(B3:B6=0))

Tom

=SUMPRODUCT(($A$2:$A$22=D1)*($A$2:$A$22<D2)*($B$2 :$B$220))
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Robin W" wrote in message
...
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

FANTASTIC!!!!! Thanks so much! Can't believe that you just solved literally
2 days of searching and searching for the help I needed!!!
--
Robin W


"TomPl" wrote:

You would need to adjust the ranges and the values in this formula to get the
results you want:

=SUMPRODUCT(--(A3:A6<30),--(A3:A625),--(B3:B6=0))

Tom

For more details on SUMPRODUCT
Bob Phillips
http://www.xldynamic.com/source/xld.SUMPRODUCT.html
J.E McGimpsey
http://mcgimpsey.com/excel/formulae/doubleneg.html

--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Robin W" wrote in message
...
FANTASTIC!!!!! Thanks so much! Can't believe that you just solved
literally
2 days of searching and searching for the help I needed!!!
--
Robin W


"TomPl" wrote:

You would need to adjust the ranges and the values in this formula to get
the
results you want:

=SUMPRODUCT(--(A3:A6<30),--(A3:A625),--(B3:B6=0))

Tom