Advertisement

October 7, 2008 07:31am pdt

Experts Exchange

Announcements Feedback

Advertisement

1. zorvek 2,544,221
2. rorya 2,138,286
3. saurabh726 1,562,559
4. chris_bot... 861,687
5. byundt 817,795
6. nutsch 587,248
7. patrickab 485,822
8. jeverist 411,038
9. matthews... 345,006
10. webtubbs 332,634
11. spattewar 326,928
12. ahammar 311,291
13. jpaulino 272,547
14. brettdj 270,650
15. RobSamp... 245,714
16. dj88 216,941
17. irudyk 210,626
18. Psychotec 189,635
19. epaclm 175,585
20. WJReid 170,237
21. weellio 147,519
22. StellanRo... 122,668
23. GrahamSkan 122,587
24. Merch_Ops 114,663
25. gtgloner 103,627

1. zorvek 9,848,712
2. byundt 7,560,884
3. rorya 5,833,017
4. matthews... 2,908,134
5. jeverist 2,821,307
6. patrickab 2,241,385
7. roos01 1,922,714
8. saurabh726 1,656,138
9. mvidas 1,529,753
10. webtubbs 1,429,026
11. brettdj 1,313,226
12. fanpages 1,234,722
13. MalicUK 1,060,396
14. chris_bot... 1,051,193
15. mgh_mgh... 649,110
16. ahammar 611,424
17. LoNeRaV... 602,049
18. nutsch 587,248
19. ture 570,551
20. spattewar 535,877
21. R_Rajesh 468,975
22. jpaulino 385,446
23. david251 367,914
24. RobSamp... 344,263
25. sebastienm 339,407

01.25.2008 at 11:49PM PST, ID: 23113116

	[x] Attachment Details

Excel Formula for calculating totals in colums

Asked by The_Big_Tuna in Microsoft Excel Spreadsheet Software

Tags: Microsoft, Excel, 2007, in Office 2007

I have a spreadsheet that has columns of product IDs as they are ordered, however I need to create a total of each item. If column A has:
0
0
WSS512
0
WSS3072
0
0
0
0
0
0
WSS512
WSS512
0
0
0
WSS3072
WSS3072
WSS5120
0

The objective would be to have the total # of WSS512 in B1, the total # of WSS3072 in C1, and the total # of WSS5120 in D1, etc.

I thank you in advance for helping! Start Free Trial

Keywords: Excel Formula for calculating totals in c…

	Title
1	=A1 in B1, =A2 in C1, =A3 in …
2	If text of column A1 matches Column …
3	Sum and Average colums based with …
4	can i say in excel in c1, if a1 = 1 t…
5	Excel sheet 2 colums need to get 2 c…
6	Help with my spreadsheet

Loading Advertisement...

20080716-EE-VQP-32 / EE_QW_2_20070628

© Copyright Experts Exchange LLC 2008. All rights reserved.