Summarizing a count of like values


M

Matt

I want to count how many times a value appears and have that value appear in
the end with a listing of the total appearances.

More specifically I have 3 columns. Column A is "Label" It doesn't really
play a factor in my example. Column B is "Type," this is important because
often times there are different types. Column C is "Length" and it is
generally pretty standard. 25, 50, 75, 100, 125, 150. Stuff like that. Say
I have 10 rows filled in with these. going from row 3-12 with all the info
filled in and there are types A and B in the type on various lengths say
three different lengths. I want Row 14 and to be A 25 and the count of
number that meet that criteria. I want row 15 to be similar like A 50 and
count.

I am thinking that maybe one cell needs to be B14 as criteria of different
types and C14 the count. and so forth. I am not sure though. If it were
possible to post an example I would show it, but for now hopefully this makes
sense.

Thanks for the help.

Matt
 
Ad

Advertisements

M

Max

Assume you have listed in B14:C14 down
the unique combinations for Type, Length such as:
A, 25
A, 50
B, 25
etc

Then you could place in D14:
=SUMPRODUCT((B$3:B$12=B14)*(C$3:C$12=C14))
and copy down to derive the required results

--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:300 Subscribers:70
xdemechanik
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top