Thank you Haseeb! This works great J
From: [email protected] [mailto:[email protected]] On Behalf Of Haseeb Avarakkan Sent: Friday, August 05, 2011 8:31 PM To: [email protected] Subject: $$Excel-Macros$$ Re: Need your help, ASAP! SUMIF across multiple sheets Hello Susan, Use sheet name as 3 alphabets like, Jan, Feb, Mar, Apr, May, Jun, Jul, Aug, Sep, Oct, Nov, Dec, not like Sept, Jul, June etc... This will give the total from Jan to current month (Aug). When next month comes, this will automatically include Sep. (Jan-Sep), for Oct (Jan-Oct), etc.... See the attached. HTH Haseeb For tips visit; http://www.excelfox.com/forum/ -- ---------------------------------------------------------------------------- ------ 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 [email protected] <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- ---------------------------------------------------------------------------------- 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 [email protected] <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
