Counting

  • Thread starter Thread starter Kreiss
  • Start date Start date
K

Kreiss

Wondering if there is a way for me to do like a group by
with a count. For example I would like to do a group by
the age and a sum of the qnty. I have no idea where to
start.......

Age BL Qnty
15 00 1
15 08 1
15 15 1
16 00 12
16 08 6
16 10 2
16 11 1

........
I would like for it to tell me.....
Age Qnty
15 3
16 21

Thanks in advance,
Kacy
 
=SUMIF(Age_Range,15,Qty_Range)

replace 15 with a cell reference where you can type in the different ages

To retrieve the unique age values use advanced filter unique records only
filter on age column)
and copy to another location
 
Kacy, the best and simplest way to do it is to do a pivot
table. It will eliminate you having to manually search,
thru filtering the age column, what age values you have as
Peo suggested. Also, the countif function suggested by
Ray will not work because your actually adding the values
in the Qnty column given a particular age. It would
probably work if all values in Qnty were equal to 1. And
even in this case, you'd still have to also search the
values in your age column.
 
Back
Top