Thanks Paul. Unfortunately the formula is too long for Excel. That's the error I got. But I certainly appreciate the effort because it does work when it's shortened. I've come up with another solution using a pivot table but it makes the file larger and more cumbersome. But, hey, it's a solution. :) Maybe someone else will have an idea that's easier to use.
________________________________ From: Paul Schreiner <schreiner_p...@att.net> To: excel-macros@googlegroups.com Sent: Tue, August 24, 2010 12:07:33 PM Subject: Re: $$Excel-Macros$$ Urgent: SUMIF + it might be a problem with the length of the function! depending your your version of Excel, it MAY have a 256 character limit. Each sumif statement is nearly than 50 characters, so 21 of them would be 1050 characters!... you may have a problem... it may mean you need to separate it into several cells, or use a VBA function to handle the calculations! Paul ________________________________ From: None <n8dine4ma...@yahoo.com> To: excel-macros@googlegroups.com Sent: Tue, August 24, 2010 1:45:31 PM Subject: Re: $$Excel-Macros$$ Urgent: SUMIF + Can this work having about 21 SUMIF formulas in one cell? ________________________________ From: None <n8dine4ma...@yahoo.com> To: excel-macros@googlegroups.com Sent: Tue, August 24, 2010 10:26:55 AM 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 -- ---------------------------------------------------------------------------------- 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
