No problem. It's not an "elegant" solution, but it works. VBA would be better (and more fun)
Paul ________________________________ From: None <n8dine4ma...@yahoo.com> To: excel-macros@googlegroups.com Sent: Tue, August 24, 2010 1:26:55 PM Subject: Re: $$Excel-Macros$$ Urgent: SUMIF + Paul: Thank you! Your "a" solution works and I'm sorry the sample was wrong. I can't thank you enough for your assistance. ________________________________ From: Paul Schreiner <schreiner_p...@att.net> To: excel-macros@googlegroups.com Sent: Tue, August 24, 2010 9:00:11 AM Subject: Re: $$Excel-Macros$$ Urgent: SUMIF + Well... I've got "A" solution: =SUMIF(Payment!EA:EA,RIGHT($A2,6),Payment!$P:$P) +SUMIF(Payment!EB:EB,RIGHT($A2,6),Payment!$U:$U) +SUMIF(Payment!EC:EC,RIGHT($A2,6),Payment!$Z:$Z) ... btw: your sample result is incorrect. rows 6 and 7 are 167891 instead of 567891, yet you included them in your calculation. this isn't the best way... I'd probably write it as VBA and loop through... hope this helps, Paul ________________________________ From: None <n8dine4ma...@yahoo.com> To: excel-macros@googlegroups.com Sent: Tue, August 24, 2010 10:50:51 AM Subject: $$Excel-Macros$$ Urgent: SUMIF + I sent this yesterday and didn't hear back and have a deadline looming. I'm really hoping someone has a solution to this dilemma. As this data changes often, manually adding up the numbers just doesn't make sense but I may have to break down and do that. Does anyone have any ideas on how to do this with a formula? Thanks for any and all ideas. Sorry for the rush on this. ----- Forwarded Message ---- From: None <n8dine4ma...@yahoo.com> To: excel-macros@googlegroups.com Sent: Mon, August 23, 2010 7:40:05 AM Subject: $$Excel-Macros$$ I need a multiple SUMIF type formula. In the attached book, there is a Log sheet that needs the formula in cells M2 and M3. The formula in cell M2 needs to look in Payment in columns EA-EU for the last 6 digits in cell M2 in the Log. If it finds it, it needs to sum the corresponding amounts in columns P, U, etc. In the Log sheet in cells O2 and O3 I've given what amount the formula should return. I'm hoping someone can help with this. Thanks so much. -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe