Re: $$Excel-Macros$$ Sum value of closing balance of date

CHeers!! On Fri, Mar 13, 2015 at 3:10 PM, Ashish Bhalara wrote: > Thank you Mr.Vaibhav:) > > Regards. > Ashish Bhalara > 9624111822 > P*Please do not print this email unless it is absolutely necessary. > Spread environmental üawareness.♣♣♣* > > > On Fri, Mar 13, 2015 at 1:28 PM, Vaibhav Joshi w

Re: $$Excel-Macros$$ Sum value of closing balance of date

Thank you Mr.Vaibhav:) Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* On Fri, Mar 13, 2015 at 1:28 PM, Vaibhav Joshi wrote: > Hi > > Check cell D20 for formula.. > > On Fri, Mar 13, 2015 at 12:43 PM, V

Re: $$Excel-Macros$$ Sum value of closing balance of date

Hi Check cell D20 for formula.. On Fri, Mar 13, 2015 at 12:43 PM, Vaibhav Joshi wrote: > Hi > > Use this array formula =SUM(IF(A3:A17<>A2:A16,D2:D16,0)) > > Cheers!! > > On Thu, Mar 12, 2015 at 3:34 PM, Ashish Bhalara > wrote: > >> Dear experts, >> >> I need function to sum only closing value

Re: $$Excel-Macros$$ Sum value of closing balance of date

Hi Use this array formula =SUM(IF(A3:A17<>A2:A16,D2:D16,0)) Cheers!! On Thu, Mar 12, 2015 at 3:34 PM, Ashish Bhalara wrote: > Dear experts, > > I need function to sum only closing value of particular date, pls see > attached file for example. > > Regards. > Ashish Bhalara > 9624111822 > P*Plea