1: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
wrote:
HI,
Answer should come to 10 as per r
Thanks Ashish and Rajan.
Its works fine.
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 @
try this
SUMIFS(B:B,A:A,">"&EOMONTH(MAX(A:A),-1))
On Sat, Jul 30, 2011 at 11:18 AM, KAUSHIK SAVLA 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 s
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
--
---
See the attached File
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of KAUSHIK SAVLA
Sent: Saturday, July 30, 2011 10:22 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ excel function required to sum data on basis of
criteria
Hi All,
