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 wrote:
> Dear Excel_Lover,
>
> PFA your query file with solved formula.
>
> Regards,
> Waseem Saifi
>
> On 7/19/13, Excel_Lover wrote:
> > Dear All,
> >
> > At
Dear Excel_Lover,
PFA your query file with solved formula.
Regards,
Waseem Saifi
On 7/19/13, Excel_Lover 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 w
ll the places you can,
At all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
-
>
>From: Excel_Lover
>To: excel-macros@googlegroups.com
>Sent: Friday, July 19, 2013 8:29 AM
ou can,
>> In all the ways you can,
>> In all the places you can,
>> At all the times you can,
>> To all the people you can,
>> As long as ever you can.” - John Wesley
>> *---------------------
>>
>>*From:* Excel_Lover
>> *
can,
> To all the people you can,
> As long as ever you can.” - John Wesley
> *-
>
> *From:* Excel_Lover
> *To:* excel-macros@googlegroups.com
> *Sent:* Friday, July 19, 2013 8:12 AM
> *Subject:* Re: $$Excel-Macros$$ To SUM Dyn
esley
-
>
>From: Excel_Lover
>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
Here's my answer:
=SUM(INDIRECT(ADDRESS(ROW(),8) & ":" & ADDRESS(ROW(),MATCH($D$1,$H$1:$Z$1)+7)))
Here's my logic:
You want to use the =SUM() function to calculate the total
for the current row from column H1 through the column described in D1.
For Jun-12, the SUM() function would look like:
=S
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
On Fri, Jul 19, 2013 at 5:05 PM, Excel_Lover 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.
>
> Appreciate if som
