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

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

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 v...@vabs.in wrote: Hi Use this array formula =SUM(IF(A3:A17A2:A16,D2:D16,0)) Cheers!! On Thu, Mar 12, 2015 at 3:34 PM, Ashish Bhalara ashishbhalar...@gmail.com wrote: Dear experts, I need function to

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 v...@vabs.in wrote: Hi Check cell D20 for formula.. On Fri, Mar 13, 2015 at

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

CHeers!! On Fri, Mar 13, 2015 at 3:10 PM, Ashish Bhalara ashishbhalar...@gmail.com 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,