Forgot to include the subject line. Sorry
________________________________ 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