Summing specific numbers...

danalee

New Member
Joined
Apr 20, 2009
Messages
26
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 Workbook
ABCDEFGHIJKL
1StoreOct-09Store9-NovStoreDec-09StoreJan-10StoreFeb-10StoreMar-10
22$ 562.501$ 937.501$ 562.502$ 562.501$ 937.501$ 937.50
33$ 750.002$ 937.503$ 750.003$ 937.502$ 750.002$ 562.50
44$ 625.003$ 937.504$ 625.005$ 750.003$ 937.503$ 937.50
57$ 1,000.004$ 625.007$ 1,000.007$ 750.005$ 1,000.005$ 750.00
69$ 750.005$ 1,250.009$ 625.009$ 500.007$ 750.007$ 750.00
711$ 1,250.007$ 1,000.0011$ 1,250.0011$ 750.009$ 750.009$ 500.00
812$ 750.009$ 750.0012$ 625.0016$ 750.0011$ 750.0011$ 750.00
914$ 1,125.0011$ 750.0014$ 937.5018$ 562.5016$ 937.5016$ 937.50
1015$ 1,125.0012$ 625.0015$ 1,125.0019$ 937.5018$ 750.0018$ 562.50
1116$ 937.5014$ 562.5016$ 1,125.0020$ 750.0019$ 937.5019$ 1,125.00
1218$ 562.5015$ 750.0019$ 937.5022$ 750.0021$ 750.0020$ 1,250.00
1319$ 1,125.0016$ 1,125.0020$ 750.0024$ 750.0022$ 1,250.0021$ 750.00
1421$ 750.0018$ 562.5022$ 1,000.0025$ 1,500.0023$ 375.0022$ 1,000.00
1525$ 1,000.0019$ 937.5023$ 375.0032$ 750.0025$ 1,000.0023$ 375.00
1626$ 1,250.0020$ 1,250.0024$ 750.0034$ 750.0026$ 750.0025$ 750.00
1727$ 562.5021$ 1,000.0025$ 750.0036$ 1,500.0027$ 562.5026$ 1,250.00
1834$ 750.0022$ 1,500.0026$ 750.0038$ 937.5028$ 1,000.0027$ 562.50
1936$ 1,500.0023$ 375.0027$ 562.5039$ 562.5031$ 1,000.0028$ 1,000.00
2037$ 375.0024$ 750.0028$ 750.0046$ 937.5032$ 375.0031$ 1,000.00
2138$ 562.5025$ 750.0032$ 750.0048$ 500.0036$ 750.0032$ 750.00
2239$ 562.5026$ 750.0034$ 750.0051$ 750.0038$ 562.5034$ 1,000.00
2341$ 500.0027$ 562.5036$ 1,250.0052$ 562.5039$ 750.0036$ 1,250.00
2442$ 625.0032$ 500.0038$ 562.5055$ 375.0040$ 750.0037$ 375.00
2546$ 562.5034$ 750.0039$ 562.5057$ 750.0041$ 500.0038$ 750.00
2648$ 500.0036$ 1,500.0040$ 750.0058$ 750.0046$ 562.5039$ 937.50
2756$ 750.0037$ 375.0046$ 562.5060$ 1,000.0047$ 375.0040$ 750.00
2857$ 750.0038$ 562.5047$ 500.0062$ 625.0048$ 375.0046$ 937.50
2958$ 625.0039$ 750.0051$ 937.5063$ 562.5049$ 750.0047$ 375.00
3060$ 1,000.0040$ 750.0052$ 750.0064$ 1,000.0050$ 562.5048$ 375.00
FY10 - GM Bonuses
Excel 2007
 

Some videos you may like

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney

Jonmo1

MrExcel MVP
Joined
Oct 12, 2006
Messages
44,061
Try

=SUMIF(A2:K30,N2,B2:L30)

N2 = Store Number to sum.


This may yield false results if any of your dollar amounts happen to be the same numerical value of a store #.
 

danalee

New Member
Joined
Apr 20, 2009
Messages
26
Richard,

This gave me a total for Store #2 of 739 instead of what should be 2812.50.

Any suggestions?
 

danalee

New Member
Joined
Apr 20, 2009
Messages
26
ABSOLUTELY PERFECT... I was leaving the "N" in the equation... Thank you so much for this help! Is there a place I can rate the people who help on this board?
 

West Man

Well-known Member
Joined
Mar 27, 2006
Messages
1,175
Try =SUMIF(A2:A30,N2,B2:B30)+SUMIF(C2:C30,N2,D2:D30)+(E2:E30,N2,F2:F30)+
(G2:G30,N2,H2:H30)+(I2:I30,N2,J2:J30)+(K2:K30,N2,L2:L30) where D2 houses the store # of interest.
 

Subscribe on YouTube

Watch MrExcel Video

Forum statistics

Threads
1,106,821
Messages
5,513,587
Members
408,962
Latest member
DCESL

This Week's Hot Topics

  • Sort code advice please
    Hi, I have the code below which im trying to edit but getting a little stuck. This was the original code which worked fine,columns A-F would sort...
  • SUMPRODUCT with nested If statement
    Hi everyone, Hope you're all well. I'm hoping someone will be able to point me in the right direction with a problem I'm having with a SUMPRODUCT...
  • VBA - simple sort is killing me!
    Hello all! This should be so easy, but not for me, apparently! I have a table of data that can be of varying lengths and widths. My current macro...
  • Compare Two Lists
    I have two Lists and I need to be able to Identify differences between them. List 100 comes from a workbook - the other is downloaded form the...
  • Formula that deducts points for each code I input.
    I am trying to create a formula that will have each student in my class start at 100 points and then for each code that I enter (PP for Poor...
  • Conditional formatting formula required for day of week and a value
    Hi, I have a really simple spreadsheet where column A is the date, column B is the activity total shown as a number and column C states the day of...
Top