Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Summarizing a count of like values
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Summarizing a count of like values
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 --- "Matt" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro summarizing count below an array of data | Excel Discussion (Misc queries) | |||
Count Intervals of 2 Consecutive Values in same Row and Return Count across Row | Excel Worksheet Functions | |||
Count Intervals of 2 Numeric values in same Row and Return Count across Row | Excel Worksheet Functions | |||
Count unique values and create list based on these values | Excel Worksheet Functions | |||
Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions |