Count Functions

[Robin W]

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?

 

[TomPl]

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

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

Tom

 

[Don Guillett]

=SUMPRODUCT(($A$2:$A$22>=D1)*($A$2:$A$22<D2)*($B$2:$B$22>0))

 

[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!!!

 

[Bernard Liengme]

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