Try this :
=SUMIFS(B:B,A:A,">"&DATE(YEAR(MAX(A:A)),MONTH(MAX(A:A)),0)) From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of ashish koul Sent: Saturday, July 30, 2011 11:35 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ excel function required to sum data on basis of criteria try this SUMIFS(B:B,A:A,">"&EOMONTH(MAX(A:A),-1)) On Sat, Jul 30, 2011 at 11:18 AM, KAUSHIK SAVLA <savla.kaus...@gmail.com> wrote: HI, Answer should come to 10 as per row no. 16 which is latest from the given data (ie May 2011 latest month from available data, and total of May 2011 is 10) But in the attavhed sheet answer is coming as 80 which is incorrect. Regards, Kaushik -- ---------------------------------------------------------------------------- ------ 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/discussexcel -- Regards Ashish Koul <http://akoul.blogspot.com/> akoul.blogspot.com http://akoul.posterous.com/ <http://akoul.wordpress.com/> akoul.wordpress.com My <http://in.linkedin.com/pub/ashish-koul/10/400/830> Linkedin Profile P Before printing, think about the environment. -- ---------------------------------------------------------------------------- ------ 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/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 excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
