Thanks so much Richard for all your help on this!
I hope this works...*smile* I need to have a formula or something that will look in Columns A,C,E,G,I & K for lets say Store #1. Everywhere it finds Store "1" I need it to add the numbers in the cell next to it with all the other #1's on the sheet. Is this possible?
Excel 2007
I hope this works...*smile* I need to have a formula or something that will look in Columns A,C,E,G,I & K for lets say Store #1. Everywhere it finds Store "1" I need it to add the numbers in the cell next to it with all the other #1's on the sheet. Is this possible?
Excel Workbook | ||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | |||
1 | Store | Oct-09 | Store | 9-Nov | Store | Dec-09 | Store | Jan-10 | Store | Feb-10 | Store | Mar-10 | ||
2 | 2 | $ 562.50 | 1 | $ 937.50 | 1 | $ 562.50 | 2 | $ 562.50 | 1 | $ 937.50 | 1 | $ 937.50 | ||
3 | 3 | $ 750.00 | 2 | $ 937.50 | 3 | $ 750.00 | 3 | $ 937.50 | 2 | $ 750.00 | 2 | $ 562.50 | ||
4 | 4 | $ 625.00 | 3 | $ 937.50 | 4 | $ 625.00 | 5 | $ 750.00 | 3 | $ 937.50 | 3 | $ 937.50 | ||
5 | 7 | $ 1,000.00 | 4 | $ 625.00 | 7 | $ 1,000.00 | 7 | $ 750.00 | 5 | $ 1,000.00 | 5 | $ 750.00 | ||
6 | 9 | $ 750.00 | 5 | $ 1,250.00 | 9 | $ 625.00 | 9 | $ 500.00 | 7 | $ 750.00 | 7 | $ 750.00 | ||
7 | 11 | $ 1,250.00 | 7 | $ 1,000.00 | 11 | $ 1,250.00 | 11 | $ 750.00 | 9 | $ 750.00 | 9 | $ 500.00 | ||
8 | 12 | $ 750.00 | 9 | $ 750.00 | 12 | $ 625.00 | 16 | $ 750.00 | 11 | $ 750.00 | 11 | $ 750.00 | ||
9 | 14 | $ 1,125.00 | 11 | $ 750.00 | 14 | $ 937.50 | 18 | $ 562.50 | 16 | $ 937.50 | 16 | $ 937.50 | ||
10 | 15 | $ 1,125.00 | 12 | $ 625.00 | 15 | $ 1,125.00 | 19 | $ 937.50 | 18 | $ 750.00 | 18 | $ 562.50 | ||
11 | 16 | $ 937.50 | 14 | $ 562.50 | 16 | $ 1,125.00 | 20 | $ 750.00 | 19 | $ 937.50 | 19 | $ 1,125.00 | ||
12 | 18 | $ 562.50 | 15 | $ 750.00 | 19 | $ 937.50 | 22 | $ 750.00 | 21 | $ 750.00 | 20 | $ 1,250.00 | ||
13 | 19 | $ 1,125.00 | 16 | $ 1,125.00 | 20 | $ 750.00 | 24 | $ 750.00 | 22 | $ 1,250.00 | 21 | $ 750.00 | ||
14 | 21 | $ 750.00 | 18 | $ 562.50 | 22 | $ 1,000.00 | 25 | $ 1,500.00 | 23 | $ 375.00 | 22 | $ 1,000.00 | ||
15 | 25 | $ 1,000.00 | 19 | $ 937.50 | 23 | $ 375.00 | 32 | $ 750.00 | 25 | $ 1,000.00 | 23 | $ 375.00 | ||
16 | 26 | $ 1,250.00 | 20 | $ 1,250.00 | 24 | $ 750.00 | 34 | $ 750.00 | 26 | $ 750.00 | 25 | $ 750.00 | ||
17 | 27 | $ 562.50 | 21 | $ 1,000.00 | 25 | $ 750.00 | 36 | $ 1,500.00 | 27 | $ 562.50 | 26 | $ 1,250.00 | ||
18 | 34 | $ 750.00 | 22 | $ 1,500.00 | 26 | $ 750.00 | 38 | $ 937.50 | 28 | $ 1,000.00 | 27 | $ 562.50 | ||
19 | 36 | $ 1,500.00 | 23 | $ 375.00 | 27 | $ 562.50 | 39 | $ 562.50 | 31 | $ 1,000.00 | 28 | $ 1,000.00 | ||
20 | 37 | $ 375.00 | 24 | $ 750.00 | 28 | $ 750.00 | 46 | $ 937.50 | 32 | $ 375.00 | 31 | $ 1,000.00 | ||
21 | 38 | $ 562.50 | 25 | $ 750.00 | 32 | $ 750.00 | 48 | $ 500.00 | 36 | $ 750.00 | 32 | $ 750.00 | ||
22 | 39 | $ 562.50 | 26 | $ 750.00 | 34 | $ 750.00 | 51 | $ 750.00 | 38 | $ 562.50 | 34 | $ 1,000.00 | ||
23 | 41 | $ 500.00 | 27 | $ 562.50 | 36 | $ 1,250.00 | 52 | $ 562.50 | 39 | $ 750.00 | 36 | $ 1,250.00 | ||
24 | 42 | $ 625.00 | 32 | $ 500.00 | 38 | $ 562.50 | 55 | $ 375.00 | 40 | $ 750.00 | 37 | $ 375.00 | ||
25 | 46 | $ 562.50 | 34 | $ 750.00 | 39 | $ 562.50 | 57 | $ 750.00 | 41 | $ 500.00 | 38 | $ 750.00 | ||
26 | 48 | $ 500.00 | 36 | $ 1,500.00 | 40 | $ 750.00 | 58 | $ 750.00 | 46 | $ 562.50 | 39 | $ 937.50 | ||
27 | 56 | $ 750.00 | 37 | $ 375.00 | 46 | $ 562.50 | 60 | $ 1,000.00 | 47 | $ 375.00 | 40 | $ 750.00 | ||
28 | 57 | $ 750.00 | 38 | $ 562.50 | 47 | $ 500.00 | 62 | $ 625.00 | 48 | $ 375.00 | 46 | $ 937.50 | ||
29 | 58 | $ 625.00 | 39 | $ 750.00 | 51 | $ 937.50 | 63 | $ 562.50 | 49 | $ 750.00 | 47 | $ 375.00 | ||
30 | 60 | $ 1,000.00 | 40 | $ 750.00 | 52 | $ 750.00 | 64 | $ 1,000.00 | 50 | $ 562.50 | 48 | $ 375.00 | ||
FY10 - GM Bonuses |