Count the frequency of values

kin

Well-known Member
Joined
Jun 26, 2007
Messages
648
Hi I have a file and would like to count the frequency that some products are being bought every month, and in the end to sum the frequency in each row for every product


Excel Workbook
ABCDEFGHI
1CUSTOMERPRODUCTJANFEBMARAPRMAYJUNTOTAL
2"LINGUA FRANCA" & ... C 25 - (5-31-054)22,6260,6183,23
3WC R SCL L CLUSV 24200. - (5-30-530)10,69,5428,6248,76
4C-560 10L . 1 . - (5-40-014)15,9215,92
5 SL -12 . - (4-52-165)14,814,8
6C 3214 14 - (4-59-022)13,2813,28
7. 12L M 2TEM - (4-64-287)11,3611,36
8U-520 4L . 4 . - (5-40-002)5,34510,34
9 . 8595 1018 . - (4-66-133)5,14,879,97
10/ . 300.. . 25 . - (5-60-313)3,373,196,56
11F-330 4L . 4 . - (5-40-063)6,526,52
12-100 10L - (5-40-526)6,196,19
13 L L 4250 100 .20. - (4-66-002)1,881,691,85,37
14R-566 4L 4 . - (5-40-032)5,265,26
15 . 6590 1025 . - (4-66-134)5,055,05
16-100 4L 4 . - (5-40-525)2,452,34,75
17 (503) 48 50 . - (4-66-068)1,162,183,34
18 SL L-12 . - (4-52-166)3,293,29
19 1,30 . 24 . - (4-58-008)2,492,49
20 . 5055 1040 . - (4-66-135)2,382,38
21 SL L-12 . - (4-52-167)1,631,63
22. 10 15 2,5 - 124 - (4-59-156)0,350,35
23TOTAL73,953,6133,34260,84
24ACTIVE COMPUTER SYSTEMS S.AVR C 10 630 . 1 . - (5-31-080)53,2453,2426,6279,87212,97
25 1 R LUS 32 - 6000 - 15 400 . - (5-31-137)28,8128,8186,43144,05
26WC EXTRA 500. . 12 (65) - (5-30-070)30,3730,3745,5530,37136,66
27VR R 10 630 . 1 . - (5-31-088)16,6116,61
28WC R SCL L CLUSV 24200. - (5-30-530)9,549,54
29TOTAL121,9683,61117,59196,67519,83
Sheet1
 

Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.
it would be nice if the sums of the counts were shown like this


Excel Workbook
ABCD
1PRODUCT NAMELINGUA 2011SHAPES 2011ACTIVECOMP 2011
2 1 R LUS 23 - 7000 - 15467 . - (5-31-005)0338,760
3VR R 10 630 . 1 . - (5-31-088)0016,61
4 FD R R 2 1000 4 ( 4-39-040) - (5-31-092)000
5 . DC 380 ( ) - (4-83-160)000
6. . . 30L (551/S) 2 . (203067) - (4-64-029)000
7 2 R LUS 223 - 4000 - 15267 . - (5-31-016)000
8 . 8595. 10 g. 1 14-15 . - (4-66-026)000
9WC R 200 . . 30 - (5-30-013)000
10WC ECO 500. .12 65 - (5-30-077)000
11 S 70 - (4-83-250)000
12WC R SCL L CLUSV 24200. - (5-30-530)48,7609,54
13F-320 4L . 4. - (5-40-065)079,110
14WC EXTRA 500. . 12 (65) - (5-30-070)0143,39136,66
Results
 
Upvote 0

Forum statistics

Threads
1,224,616
Messages
6,179,912
Members
452,949
Latest member
beartooth91

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top