First of all thank you for any effort put in this direction. I am having problems with a couple excel formulas that I really need to get right for a client.
Here is the deal: WORKSHEET 1 Column1 = email address Column2 = ***This column I want the sum of events on new years but having problems (Stuck)**** WORKSHEET 2 Column1 = email address Column2 = if an event is on new years indicated with a 1 if it is on new years and blank if it is not. I guess where I am confused is I do not know if it is best to do the summing in a column3 of WORKSHEET 2 and then use a Vlookup to pull that data into Column2 of WORKSHEET 1. OR if the summing should happen in the same formula as the vlookup?? Any help with this is most appreciated! One thousand thank you's! -Michael -- ---------------------------------------------------------------------------------- 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 <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts