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

Reply via email to