PFA with solution
Regards,
Waseem Saifi
On Fri, Aug 23, 2013 at 12:36 PM, ravinder negi wrote:
> PFA
>
> --
> *From:* Ali Abbas
> *To:* excel-macros@googlegroups.com
> *Sent:* Thursday, August 22, 2013 9:01 PM
>
> *Subject:* $$Excel-Macros$$ Sum if array for cut
PFA
From: Ali Abbas
To: excel-macros@googlegroups.com
Sent: Thursday, August 22, 2013 9:01 PM
Subject: $$Excel-Macros$$ Sum if array for cut dates
Date: 1 2 3 4
Amount: 100 200 300 400
Now formula working.
We can calculate value with arr
dear sir formula not work plz help.
On Aug 22, 2013 5:34 PM, "Ali Abbas" wrote:
> thanks brother
> On Aug 22, 2013 4:14 PM, wrote:
>
>> **
>> You can use sumproduct also
>>
>> =sumproduct(--(and((a:a)>=c1,(a:a)<=c2),b:b)
>>
>> Assuming dates are in a row , amount are in b row. C1=smaller cutoff
thanks brother
On Aug 22, 2013 4:14 PM, wrote:
> **
> You can use sumproduct also
>
> =sumproduct(--(and((a:a)>=c1,(a:a)<=c2),b:b)
>
> Assuming dates are in a row , amount are in b row. C1=smaller cutoff date
> and c2=latest date .
>
> Hope it works for you! :)
> Sandeep
> Sent on my BlackBerry®
You can use sumproduct also
=sumproduct(--(and((a:a)>=c1,(a:a)<=c2),b:b)
Assuming dates are in a row , amount are in b row. C1=smaller cutoff date and
c2=latest date .
Hope it works for you! :)
Sandeep
Sent on my BlackBerry® from Vodafone
-Original Message-
From: Ali Abbas
Sender:
