Re: $$Excel-Macros$$ To SUM Dynamic Columns

2013-07-20 Thread Waseem Saifi
Dear Excel_Lover, PFA your query file with solved formula. Regards, Waseem Saifi On 7/19/13, Excel_Lover idforex...@gmail.com wrote: Dear All, Attached is a sample data in which I have some month wise item total, I need a formula which can calculate SUM of an item from the Month Jan-12 to

Re: $$Excel-Macros$$ To SUM Dynamic Columns

2013-07-20 Thread Waseem Saifi
Dear Excel_Lover, it is exactly in attachment you are asking for. Regards, Waseem Saifi On Sat, Jul 20, 2013 at 2:12 PM, Waseem Saifi waseemsa...@gmail.com wrote: Dear Excel_Lover, PFA your query file with solved formula. Regards, Waseem Saifi On 7/19/13, Excel_Lover

$$Excel-Macros$$ To SUM Dynamic Columns

2013-07-19 Thread Excel_Lover
Dear All, Attached is a sample data in which I have some month wise item total, I need a formula which can calculate SUM of an item from the Month Jan-12 to till the month which we are selecting in the column D1. Appreciate if somebody can help me with formula. Best Regards Excel_Lover --

Re: $$Excel-Macros$$ To SUM Dynamic Columns

2013-07-19 Thread Deepak Barnwal
On Fri, Jul 19, 2013 at 5:05 PM, Excel_Lover idforex...@gmail.com wrote: Dear All, Attached is a sample data in which I have some month wise item total, I need a formula which can calculate SUM of an item from the Month Jan-12 to till the month which we are selecting in the column D1.

Re: $$Excel-Macros$$ To SUM Dynamic Columns

2013-07-19 Thread Excel_Lover
Dear Mr.Deepak, Thanks for a quick reply, your formula works fine but it's not considering the items (A,B,C,D etc), it should also be a criteria because its order may vary. Hope it needed a formula like SUMIF which provides SUM by multiple criteria. Thanks again.. On Fri, Jul 19, 2013 at 2:58

Re: $$Excel-Macros$$ To SUM Dynamic Columns

2013-07-19 Thread Paul Schreiner
@googlegroups.com Sent: Friday, July 19, 2013 7:35 AM Subject: $$Excel-Macros$$ To SUM Dynamic Columns Dear All, Attached is a sample data in which I have some month wise item total, I need a formula which can calculate SUM of an item from the Month Jan-12 to till the month which  we are selecting

Re: $$Excel-Macros$$ To SUM Dynamic Columns

2013-07-19 Thread Paul Schreiner
- From: Excel_Lover idforex...@gmail.com To: excel-macros@googlegroups.com Sent: Friday, July 19, 2013 8:12 AM Subject: Re: $$Excel-Macros$$ To SUM Dynamic Columns Dear Mr.Deepak, Thanks for a quick reply, your formula works fine but it's not considering the items (A,B,C,D etc

Re: $$Excel-Macros$$ To SUM Dynamic Columns

2013-07-19 Thread Excel_Lover
as ever you can.” - John Wesley *- *From:* Excel_Lover idforex...@gmail.com *To:* excel-macros@googlegroups.com *Sent:* Friday, July 19, 2013 8:12 AM *Subject:* Re: $$Excel-Macros$$ To SUM Dynamic Columns Dear Mr.Deepak, Thanks for a quick reply

Re: $$Excel-Macros$$ To SUM Dynamic Columns

2013-07-19 Thread Excel_Lover
.” - John Wesley *- *From:* Excel_Lover idforex...@gmail.com *To:* excel-macros@googlegroups.com *Sent:* Friday, July 19, 2013 8:12 AM *Subject:* Re: $$Excel-Macros$$ To SUM Dynamic Columns Dear Mr.Deepak, Thanks for a quick reply, your formula works

Re: $$Excel-Macros$$ To SUM Dynamic Columns

2013-07-19 Thread Paul Schreiner
as ever you can.” - John Wesley - From: Excel_Lover idforex...@gmail.com To: excel-macros@googlegroups.com Sent: Friday, July 19, 2013 8:29 AM Subject: Re: $$Excel-Macros$$ To SUM Dynamic Columns Dear Mr.Paul, I am