Re: $$Excel-Macros$$ Total of values

[Smitha S R]

Hi Premor,
Really thanks a lot , very much cleared and inspired by your mail.


On Thu, Jul 18, 2013 at 7:11 PM, De Premor  wrote:

>  Sorry for my late response, a have to take a rest for a while (^_^)
>
>
>
> *=SUM(IFERROR((Sheet1!$A$3:$E$6=$A4)*(Sheet1!$B$3:$F$6),0))**
> ** *
> The short explanation on my formula is
>
> 1. Fist we check the range data in sheet1
>
>  *Sheet1!$A$3:$E$6=$A4
> *
> This* *formula will give TRUE / FALSE result if in each cell in given
> range = value in cell A4
> As we know, that value of TRUE is 1 and FALSE is 0, wee need this for
> next calculation to eliminate unwanted value
>
> That formula will result like in image bellow, as we see we found TRUE
> value in Col 2 Row 3, and Col 3 Row 2, just like we see in Sheet1
>
>
> 2. As we see on your data table in sheet1, the value that we want was 1
> column right after the keyword that we test in fist part formula, soo to
> make it easy to calculate our wanted value we need to move our
> calculation range by 1 column  to the right
> *(Sheet1!$B$3:$F$6)
> *
> *
>
> *3.* *After we have temporary result, soo we need to clean up that error by
> replacing error with 0 using IFERROR formula
>
>
>
> 4. After we got clean value after IFERROR operation, we can SUM it like
> we do as usual, but at this time we need to use CSE because that was
> array formula
>
> * **Thats All (^.^)*
>
> After we know the main concept of that formulas, we can solve your next
> question with this formula
> *
> =SUM(IFERROR((Sheet1!$A$3:$G$6=$A4)*(Sheet1!$C$3:$I$6),0))  => *Red Value
> Shifted 2 Column*
> **
> *Rgds,
> [dp]
>
>
> Pada 18/07/2013 19:27, Smitha S R menulis:
>
>  Hi premor,
>
>  Please help
>
>
>  --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.


<><><><>

Re: $$Excel-Macros$$ Total of values

[De Premor]

Sorry for my late response, a have to take a rest for a while (^_^)



*=SUM(IFERROR((Sheet1!$A$3:$E$6=$A4)*(Sheet1!$B$3:$F$6),0))**
***
The short explanation on my formula is

1. Fist we check the range data in sheet1

*Sheet1!$A$3:$E$6=$A4
*
This**formula will give TRUE / FALSE result if in each cell in given 
range = value in cell A4
As we know, that value of TRUE is 1 and FALSE is 0, wee need this 
for next calculation to eliminate unwanted value


That formula will result like in image bellow, as we see we found 
TRUE value in Col 2 Row 3, and Col 3 Row 2, just like we see in Sheet1



2. As we see on your data table in sheet1, the value that we want was 1 
column right after the keyword that we test in fist part formula, soo to 
make it easy to calculate our wanted value we need to move our 
calculation range by 1 column  to the right

*(Sheet1!$B$3:$F$6)
*
*

*3.**After we have temporary result, soo we need to clean up that error 
by replacing error with 0 using IFERROR formula




4. After we got clean value after IFERROR operation, we can SUM it like 
we do as usual, but at this time we need to use CSE because that was 
array formula


***Thats All (^.^)*

After we know the main concept of that formulas, we can solve your next 
question with this formula

*
=SUM(IFERROR((Sheet1!$A$3:$G$6=$A4)*(Sheet1!$C$3:$I$6),0)) => *Red Value 
Shifted 2 Column*

**
*Rgds,
[dp]


Pada 18/07/2013 19:27, Smitha S R menulis:

Hi premor,

Please help



--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group.

To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.


<><><><>

Re: $$Excel-Macros$$ Total of values

[Dileep Kumar]

Can you please be more clear... of your requirement.


On Thu, Jul 18, 2013 at 6:40 PM, Smitha S R  wrote:

> Hi Dileep,
>
> Thanks for your suggestion, but if there is lot of columns to be summed
> up, applying formula one by one column will be hectic
>
>
> On Thu, Jul 18, 2013 at 6:07 PM, Dileep Kumar  wrote:
>
>> Hi Smitha,
>>
>> if your format your data in table form which includes date column then
>> you can easily do this by using SUMIFS. I am giveing you the sample data
>> format below
>> AB   CD
>> 1 Date   Name Item  No
>> 2  1/7/13 Sam  Text   5
>> 3  1/7/13 David Words   10
>> 4  2/7/13 KantheSente   10
>> 5  2/7/13 Same Text  8
>> 6  3/7/13 David  words6
>> 7  3/7/13 Kanthe   Sente 5
>>
>>
>> =sumif(D2:D7,C2:C7,C2B2:B7,B2,A2:A7,">="&A2,A2:A7,"<="&A7)
>>
>> and you can also use filters to the table and dynamic summing function
>> for filtered range with help of subtotal
>>
>> =subtotal(109,D2:D7)
>>
>>
>>
>> On Thu, Jul 18, 2013 at 5:33 PM, Smitha S R  wrote:
>>
>>>
>>> Hi,
>>>
>>> PFA the attachement, I have applied the formula suggested by De Premor,
>>> but after including one more column. Now the formula is not working.
>>> Please help.
>>>
>>>
>>> On Thu, Jul 18, 2013 at 4:25 PM, P.VIJAYKUMAR wrote:
>>>
 Respected Smitha,

 Array formulas do not allow adding or deleting rows or columns in the
 range of the formula .The formula  range  needs to be modified if any rows
 or columns are needed to be added or  deleted. This is a best video on you
 tube about array formulas
 http://www.youtube.com/watch?v=Ae7iie8J3Dw

 Regards,
 Vijaykumar


 On Thu, Jul 18, 2013 at 4:11 PM, Smitha S R wrote:

> Thanks a  lot Vijay,
> Applying the formula suggested by Premor works. but if I insert one
> column in between before values. values becomes zero.
> Please help out.
>
>
> On Thu, Jul 18, 2013 at 4:07 PM, P.VIJAYKUMAR wrote:
>
>> Respected Smitha,
>>
>> The braces appear by  pressing Ctrl+Shift+Enter.This converts the
>> normal formal in to an array formula.Array formulas have a great and
>> extensive use in excel.For more information on Array Formulas you can 
>> check
>> the following links.
>> http://www.cpearson.com/excel/arrayformulas.aspx
>>
>> http://office.microsoft.com/en-in/excel-help/introducing-array-formulas-in-excel-HA001087290.aspx
>>
>> http://www.dummies.com/how-to/content/how-to-build-an-array-formula-in-excel-2010.html
>>
>> http://spreadsheets.about.com/od/excelformulas/tp/Excel-Array-Formula-Tutorials.htm
>> http://www.mrexcel.com/articles/CSE-array-formulas-excel.php.
>>
>> There are also many other sites just google for array formulas or CSE
>>  formulas.
>>
>> Regards,
>> VijayKumar
>>
>>
>>
>> On Thu, Jul 18, 2013 at 3:36 PM, Smitha S R wrote:
>>
>>> Hi Premor,
>>>
>>> Thanks for the support, how the {, braces appear there? and by
>>> removing that  formala is not working
>>>
>>>
>>>
>>> On Thu, Jul 18, 2013 at 1:46 PM, De Premor  wrote:
>>>
  Is like attached ?


 On 18/07/2013 14:52, Smitha S R wrote:

  Hi Team,

  Any one please help on this, as I am stuck with one report and can
 move forward only after solving this.


 On Thu, Jul 18, 2013 at 12:57 PM, Smitha S R 
 wrote:

>Hi Team,
>
>  PFA the work book, I have to get the total values in all the
> column in another sheet wherever the same name appears.
>  Please see the attachment and help it at the earliest.
>  Assume that the values are there for 30 columns.
>
>  Thanks Smitha
>  --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna
> be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this 
> forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like
> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and 
> Need
> Advice will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any
> security measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message bec

Re: $$Excel-Macros$$ Total of values

[Smitha S R]

Hi Dileep,

Thanks for your suggestion, but if there is lot of columns to be summed up,
applying formula one by one column will be hectic


On Thu, Jul 18, 2013 at 6:07 PM, Dileep Kumar  wrote:

> Hi Smitha,
>
> if your format your data in table form which includes date column then you
> can easily do this by using SUMIFS. I am giveing you the sample data format
> below
> AB   CD
> 1 Date   Name Item  No
> 2  1/7/13 Sam  Text   5
> 3  1/7/13 David Words   10
> 4  2/7/13 KantheSente   10
> 5  2/7/13 Same Text  8
> 6  3/7/13 David  words6
> 7  3/7/13 Kanthe   Sente 5
>
>
> =sumif(D2:D7,C2:C7,C2B2:B7,B2,A2:A7,">="&A2,A2:A7,"<="&A7)
>
> and you can also use filters to the table and dynamic summing function for
> filtered range with help of subtotal
>
> =subtotal(109,D2:D7)
>
>
>
> On Thu, Jul 18, 2013 at 5:33 PM, Smitha S R  wrote:
>
>>
>> Hi,
>>
>> PFA the attachement, I have applied the formula suggested by De Premor,
>> but after including one more column. Now the formula is not working.
>> Please help.
>>
>>
>> On Thu, Jul 18, 2013 at 4:25 PM, P.VIJAYKUMAR wrote:
>>
>>> Respected Smitha,
>>>
>>> Array formulas do not allow adding or deleting rows or columns in the
>>> range of the formula .The formula  range  needs to be modified if any rows
>>> or columns are needed to be added or  deleted. This is a best video on you
>>> tube about array formulas
>>> http://www.youtube.com/watch?v=Ae7iie8J3Dw
>>>
>>> Regards,
>>> Vijaykumar
>>>
>>>
>>> On Thu, Jul 18, 2013 at 4:11 PM, Smitha S R wrote:
>>>
 Thanks a  lot Vijay,
 Applying the formula suggested by Premor works. but if I insert one
 column in between before values. values becomes zero.
 Please help out.


 On Thu, Jul 18, 2013 at 4:07 PM, P.VIJAYKUMAR wrote:

> Respected Smitha,
>
> The braces appear by  pressing Ctrl+Shift+Enter.This converts the
> normal formal in to an array formula.Array formulas have a great and
> extensive use in excel.For more information on Array Formulas you can 
> check
> the following links.
> http://www.cpearson.com/excel/arrayformulas.aspx
>
> http://office.microsoft.com/en-in/excel-help/introducing-array-formulas-in-excel-HA001087290.aspx
>
> http://www.dummies.com/how-to/content/how-to-build-an-array-formula-in-excel-2010.html
>
> http://spreadsheets.about.com/od/excelformulas/tp/Excel-Array-Formula-Tutorials.htm
> http://www.mrexcel.com/articles/CSE-array-formulas-excel.php.
>
> There are also many other sites just google for array formulas or CSE
>  formulas.
>
> Regards,
> VijayKumar
>
>
>
> On Thu, Jul 18, 2013 at 3:36 PM, Smitha S R wrote:
>
>> Hi Premor,
>>
>> Thanks for the support, how the {, braces appear there? and by
>> removing that  formala is not working
>>
>>
>>
>> On Thu, Jul 18, 2013 at 1:46 PM, De Premor  wrote:
>>
>>>  Is like attached ?
>>>
>>>
>>> On 18/07/2013 14:52, Smitha S R wrote:
>>>
>>>  Hi Team,
>>>
>>>  Any one please help on this, as I am stuck with one report and can
>>> move forward only after solving this.
>>>
>>>
>>> On Thu, Jul 18, 2013 at 12:57 PM, Smitha S R 
>>> wrote:
>>>
Hi Team,

  PFA the work book, I have to get the total values in all the
 column in another sheet wherever the same name appears.
  Please see the attachment and help it at the earliest.
  Assume that the values are there for 30 columns.

  Thanks Smitha
  --
 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna
 be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this 
 forum @
 https://www.facebook.com/discussexcel

 FORUM RULES

 1) Use concise, accurate thread titles. Poor thread titles, like
 Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
 Advice will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any
 security measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum
 owners and members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google
 Groups "MS EXCEL AND VBA MACROS" group.
 To unsubscribe from this group and stop receiving emails from it,
 send an email to excel-macros+unsubscr...@googlegroups.com.
 To post to this group, send 

Re: $$Excel-Macros$$ Total of values

[Dileep Kumar]

=sumifs(D2:D7,C2:C7,C2B2:B7,B2,
A2:A7,">="&A2,A2:A7,"<="&A7)


On Thu, Jul 18, 2013 at 6:07 PM, Dileep Kumar  wrote:

> Hi Smitha,
>
> if your format your data in table form which includes date column then you
> can easily do this by using SUMIFS. I am giveing you the sample data format
> below
> AB   CD
> 1 Date   Name Item  No
> 2  1/7/13 Sam  Text   5
> 3  1/7/13 David Words   10
> 4  2/7/13 KantheSente   10
> 5  2/7/13 Same Text  8
> 6  3/7/13 David  words6
> 7  3/7/13 Kanthe   Sente 5
>
>
> =sumif(D2:D7,C2:C7,C2B2:B7,B2,A2:A7,">="&A2,A2:A7,"<="&A7)
>
> and you can also use filters to the table and dynamic summing function for
> filtered range with help of subtotal
>
> =subtotal(109,D2:D7)
>
>
>
> On Thu, Jul 18, 2013 at 5:33 PM, Smitha S R  wrote:
>
>>
>> Hi,
>>
>> PFA the attachement, I have applied the formula suggested by De Premor,
>> but after including one more column. Now the formula is not working.
>> Please help.
>>
>>
>> On Thu, Jul 18, 2013 at 4:25 PM, P.VIJAYKUMAR wrote:
>>
>>> Respected Smitha,
>>>
>>> Array formulas do not allow adding or deleting rows or columns in the
>>> range of the formula .The formula  range  needs to be modified if any rows
>>> or columns are needed to be added or  deleted. This is a best video on you
>>> tube about array formulas
>>> http://www.youtube.com/watch?v=Ae7iie8J3Dw
>>>
>>> Regards,
>>> Vijaykumar
>>>
>>>
>>> On Thu, Jul 18, 2013 at 4:11 PM, Smitha S R wrote:
>>>
 Thanks a  lot Vijay,
 Applying the formula suggested by Premor works. but if I insert one
 column in between before values. values becomes zero.
 Please help out.


 On Thu, Jul 18, 2013 at 4:07 PM, P.VIJAYKUMAR wrote:

> Respected Smitha,
>
> The braces appear by  pressing Ctrl+Shift+Enter.This converts the
> normal formal in to an array formula.Array formulas have a great and
> extensive use in excel.For more information on Array Formulas you can 
> check
> the following links.
> http://www.cpearson.com/excel/arrayformulas.aspx
>
> http://office.microsoft.com/en-in/excel-help/introducing-array-formulas-in-excel-HA001087290.aspx
>
> http://www.dummies.com/how-to/content/how-to-build-an-array-formula-in-excel-2010.html
>
> http://spreadsheets.about.com/od/excelformulas/tp/Excel-Array-Formula-Tutorials.htm
> http://www.mrexcel.com/articles/CSE-array-formulas-excel.php.
>
> There are also many other sites just google for array formulas or CSE
>  formulas.
>
> Regards,
> VijayKumar
>
>
>
> On Thu, Jul 18, 2013 at 3:36 PM, Smitha S R wrote:
>
>> Hi Premor,
>>
>> Thanks for the support, how the {, braces appear there? and by
>> removing that  formala is not working
>>
>>
>>
>> On Thu, Jul 18, 2013 at 1:46 PM, De Premor  wrote:
>>
>>>  Is like attached ?
>>>
>>>
>>> On 18/07/2013 14:52, Smitha S R wrote:
>>>
>>>  Hi Team,
>>>
>>>  Any one please help on this, as I am stuck with one report and can
>>> move forward only after solving this.
>>>
>>>
>>> On Thu, Jul 18, 2013 at 12:57 PM, Smitha S R 
>>> wrote:
>>>
Hi Team,

  PFA the work book, I have to get the total values in all the
 column in another sheet wherever the same name appears.
  Please see the attachment and help it at the earliest.
  Assume that the values are there for 30 columns.

  Thanks Smitha
  --
 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna
 be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this 
 forum @
 https://www.facebook.com/discussexcel

 FORUM RULES

 1) Use concise, accurate thread titles. Poor thread titles, like
 Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
 Advice will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any
 security measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum
 owners and members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google
 Groups "MS EXCEL AND VBA MACROS" group.
 To unsubscribe from this group and stop receiving emails from it,
 send an email to excel-macros+unsubscr...@googlegroups.com.
 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at http://g

Re: $$Excel-Macros$$ Total of values

[Dileep Kumar]

Hi Smitha,

if your format your data in table form which includes date column then you
can easily do this by using SUMIFS. I am giveing you the sample data format
below
AB   CD
1 Date   Name Item  No
2  1/7/13 Sam  Text   5
3  1/7/13 David Words   10
4  2/7/13 KantheSente   10
5  2/7/13 Same Text  8
6  3/7/13 David  words6
7  3/7/13 Kanthe   Sente 5


=sumif(D2:D7,C2:C7,C2B2:B7,B2,A2:A7,">="&A2,A2:A7,"<="&A7)

and you can also use filters to the table and dynamic summing function for
filtered range with help of subtotal

=subtotal(109,D2:D7)



On Thu, Jul 18, 2013 at 5:33 PM, Smitha S R  wrote:

>
> Hi,
>
> PFA the attachement, I have applied the formula suggested by De Premor,
> but after including one more column. Now the formula is not working.
> Please help.
>
>
> On Thu, Jul 18, 2013 at 4:25 PM, P.VIJAYKUMAR wrote:
>
>> Respected Smitha,
>>
>> Array formulas do not allow adding or deleting rows or columns in the
>> range of the formula .The formula  range  needs to be modified if any rows
>> or columns are needed to be added or  deleted. This is a best video on you
>> tube about array formulas
>> http://www.youtube.com/watch?v=Ae7iie8J3Dw
>>
>> Regards,
>> Vijaykumar
>>
>>
>> On Thu, Jul 18, 2013 at 4:11 PM, Smitha S R  wrote:
>>
>>> Thanks a  lot Vijay,
>>> Applying the formula suggested by Premor works. but if I insert one
>>> column in between before values. values becomes zero.
>>> Please help out.
>>>
>>>
>>> On Thu, Jul 18, 2013 at 4:07 PM, P.VIJAYKUMAR wrote:
>>>
 Respected Smitha,

 The braces appear by  pressing Ctrl+Shift+Enter.This converts the
 normal formal in to an array formula.Array formulas have a great and
 extensive use in excel.For more information on Array Formulas you can check
 the following links.
 http://www.cpearson.com/excel/arrayformulas.aspx

 http://office.microsoft.com/en-in/excel-help/introducing-array-formulas-in-excel-HA001087290.aspx

 http://www.dummies.com/how-to/content/how-to-build-an-array-formula-in-excel-2010.html

 http://spreadsheets.about.com/od/excelformulas/tp/Excel-Array-Formula-Tutorials.htm
 http://www.mrexcel.com/articles/CSE-array-formulas-excel.php.

 There are also many other sites just google for array formulas or CSE
  formulas.

 Regards,
 VijayKumar



 On Thu, Jul 18, 2013 at 3:36 PM, Smitha S R wrote:

> Hi Premor,
>
> Thanks for the support, how the {, braces appear there? and by
> removing that  formala is not working
>
>
>
> On Thu, Jul 18, 2013 at 1:46 PM, De Premor  wrote:
>
>>  Is like attached ?
>>
>>
>> On 18/07/2013 14:52, Smitha S R wrote:
>>
>>  Hi Team,
>>
>>  Any one please help on this, as I am stuck with one report and can
>> move forward only after solving this.
>>
>>
>> On Thu, Jul 18, 2013 at 12:57 PM, Smitha S R wrote:
>>
>>>Hi Team,
>>>
>>>  PFA the work book, I have to get the total values in all the column
>>> in another sheet wherever the same name appears.
>>>  Please see the attachment and help it at the earliest.
>>>  Assume that the values are there for 30 columns.
>>>
>>>  Thanks Smitha
>>>  --
>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>>> https://www.facebook.com/discussexcel
>>>
>>> FORUM RULES
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like
>>> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
>>> Advice will not get quick attention or may not be answered.
>>> 2) Don't post a question in the thread of another member.
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>> 4) Acknowledge the responses you receive, good or bad.
>>> 5) Jobs posting is not allowed.
>>> 6) Sharing copyrighted material and their links is not allowed.
>>>
>>> NOTE : Don't ever post confidential data in a workbook. Forum owners
>>> and members are not responsible for any loss.
>>> ---
>>> You received this message because you are subscribed to the Google
>>> Groups "MS EXCEL AND VBA MACROS" group.
>>> To unsubscribe from this group and stop receiving emails from it,
>>> send an email to excel-macros+unsubscr...@googlegroups.com.
>>> To post to this group, send email to excel-macros@googlegroups.com.
>>> Visit this group at http://groups.google.com/group/excel-macros.
>>> For more options, visit https://groups.google.com/groups/opt_out.
>>>
>>>
>>>
>>
>>  --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this 

Re: $$Excel-Macros$$ Total of values

[Smitha S R]

Hi premor,

Please help


On Thu, Jul 18, 2013 at 5:33 PM, Smitha S R  wrote:

>
> Hi,
>
> PFA the attachement, I have applied the formula suggested by De Premor,
> but after including one more column. Now the formula is not working.
> Please help.
>
>
> On Thu, Jul 18, 2013 at 4:25 PM, P.VIJAYKUMAR wrote:
>
>> Respected Smitha,
>>
>> Array formulas do not allow adding or deleting rows or columns in the
>> range of the formula .The formula  range  needs to be modified if any rows
>> or columns are needed to be added or  deleted. This is a best video on you
>> tube about array formulas
>> http://www.youtube.com/watch?v=Ae7iie8J3Dw
>>
>> Regards,
>> Vijaykumar
>>
>>
>> On Thu, Jul 18, 2013 at 4:11 PM, Smitha S R  wrote:
>>
>>> Thanks a  lot Vijay,
>>> Applying the formula suggested by Premor works. but if I insert one
>>> column in between before values. values becomes zero.
>>> Please help out.
>>>
>>>
>>> On Thu, Jul 18, 2013 at 4:07 PM, P.VIJAYKUMAR wrote:
>>>
 Respected Smitha,

 The braces appear by  pressing Ctrl+Shift+Enter.This converts the
 normal formal in to an array formula.Array formulas have a great and
 extensive use in excel.For more information on Array Formulas you can check
 the following links.
 http://www.cpearson.com/excel/arrayformulas.aspx

 http://office.microsoft.com/en-in/excel-help/introducing-array-formulas-in-excel-HA001087290.aspx

 http://www.dummies.com/how-to/content/how-to-build-an-array-formula-in-excel-2010.html

 http://spreadsheets.about.com/od/excelformulas/tp/Excel-Array-Formula-Tutorials.htm
 http://www.mrexcel.com/articles/CSE-array-formulas-excel.php.

 There are also many other sites just google for array formulas or CSE
  formulas.

 Regards,
 VijayKumar



 On Thu, Jul 18, 2013 at 3:36 PM, Smitha S R wrote:

> Hi Premor,
>
> Thanks for the support, how the {, braces appear there? and by
> removing that  formala is not working
>
>
>
> On Thu, Jul 18, 2013 at 1:46 PM, De Premor  wrote:
>
>>  Is like attached ?
>>
>>
>> On 18/07/2013 14:52, Smitha S R wrote:
>>
>>  Hi Team,
>>
>>  Any one please help on this, as I am stuck with one report and can
>> move forward only after solving this.
>>
>>
>> On Thu, Jul 18, 2013 at 12:57 PM, Smitha S R wrote:
>>
>>>Hi Team,
>>>
>>>  PFA the work book, I have to get the total values in all the column
>>> in another sheet wherever the same name appears.
>>>  Please see the attachment and help it at the earliest.
>>>  Assume that the values are there for 30 columns.
>>>
>>>  Thanks Smitha
>>>  --
>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>>> https://www.facebook.com/discussexcel
>>>
>>> FORUM RULES
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like
>>> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
>>> Advice will not get quick attention or may not be answered.
>>> 2) Don't post a question in the thread of another member.
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>> 4) Acknowledge the responses you receive, good or bad.
>>> 5) Jobs posting is not allowed.
>>> 6) Sharing copyrighted material and their links is not allowed.
>>>
>>> NOTE : Don't ever post confidential data in a workbook. Forum owners
>>> and members are not responsible for any loss.
>>> ---
>>> You received this message because you are subscribed to the Google
>>> Groups "MS EXCEL AND VBA MACROS" group.
>>> To unsubscribe from this group and stop receiving emails from it,
>>> send an email to excel-macros+unsubscr...@googlegroups.com.
>>> To post to this group, send email to excel-macros@googlegroups.com.
>>> Visit this group at http://groups.google.com/group/excel-macros.
>>> For more options, visit https://groups.google.com/groups/opt_out.
>>>
>>>
>>>
>>
>>  --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like
>> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
>> Advice will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.

Re: $$Excel-Macros$$ Total of values

[Smitha S R]

Hi,

PFA the attachement, I have applied the formula suggested by De Premor, but
after including one more column. Now the formula is not working.
Please help.


On Thu, Jul 18, 2013 at 4:25 PM, P.VIJAYKUMAR  wrote:

> Respected Smitha,
>
> Array formulas do not allow adding or deleting rows or columns in the
> range of the formula .The formula  range  needs to be modified if any rows
> or columns are needed to be added or  deleted. This is a best video on you
> tube about array formulas
> http://www.youtube.com/watch?v=Ae7iie8J3Dw
>
> Regards,
> Vijaykumar
>
>
> On Thu, Jul 18, 2013 at 4:11 PM, Smitha S R  wrote:
>
>> Thanks a  lot Vijay,
>> Applying the formula suggested by Premor works. but if I insert one
>> column in between before values. values becomes zero.
>> Please help out.
>>
>>
>> On Thu, Jul 18, 2013 at 4:07 PM, P.VIJAYKUMAR wrote:
>>
>>> Respected Smitha,
>>>
>>> The braces appear by  pressing Ctrl+Shift+Enter.This converts the normal
>>> formal in to an array formula.Array formulas have a great and extensive use
>>> in excel.For more information on Array Formulas you can check the following
>>> links.
>>> http://www.cpearson.com/excel/arrayformulas.aspx
>>>
>>> http://office.microsoft.com/en-in/excel-help/introducing-array-formulas-in-excel-HA001087290.aspx
>>>
>>> http://www.dummies.com/how-to/content/how-to-build-an-array-formula-in-excel-2010.html
>>>
>>> http://spreadsheets.about.com/od/excelformulas/tp/Excel-Array-Formula-Tutorials.htm
>>> http://www.mrexcel.com/articles/CSE-array-formulas-excel.php.
>>>
>>> There are also many other sites just google for array formulas or CSE
>>>  formulas.
>>>
>>> Regards,
>>> VijayKumar
>>>
>>>
>>>
>>> On Thu, Jul 18, 2013 at 3:36 PM, Smitha S R wrote:
>>>
 Hi Premor,

 Thanks for the support, how the {, braces appear there? and by removing
 that  formala is not working



 On Thu, Jul 18, 2013 at 1:46 PM, De Premor  wrote:

>  Is like attached ?
>
>
> On 18/07/2013 14:52, Smitha S R wrote:
>
>  Hi Team,
>
>  Any one please help on this, as I am stuck with one report and can
> move forward only after solving this.
>
>
> On Thu, Jul 18, 2013 at 12:57 PM, Smitha S R wrote:
>
>>Hi Team,
>>
>>  PFA the work book, I have to get the total values in all the column
>> in another sheet wherever the same name appears.
>>  Please see the attachment and help it at the earliest.
>>  Assume that the values are there for 30 columns.
>>
>>  Thanks Smitha
>>  --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like
>> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
>> Advice will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners
>> and members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google
>> Groups "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it,
>> send an email to excel-macros+unsubscr...@googlegroups.com.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/groups/opt_out.
>>
>>
>>
>
>  --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like
> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
> Advice will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners
> and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google
>>

Re: $$Excel-Macros$$ Total of values

[P.VIJAYKUMAR]

Respected Smitha,

Array formulas do not allow adding or deleting rows or columns in the range
of the formula .The formula  range  needs to be modified if any rows or
columns are needed to be added or  deleted. This is a best video on you
tube about array formulas
http://www.youtube.com/watch?v=Ae7iie8J3Dw

Regards,
Vijaykumar


On Thu, Jul 18, 2013 at 4:11 PM, Smitha S R  wrote:

> Thanks a  lot Vijay,
> Applying the formula suggested by Premor works. but if I insert one column
> in between before values. values becomes zero.
> Please help out.
>
>
> On Thu, Jul 18, 2013 at 4:07 PM, P.VIJAYKUMAR wrote:
>
>> Respected Smitha,
>>
>> The braces appear by  pressing Ctrl+Shift+Enter.This converts the normal
>> formal in to an array formula.Array formulas have a great and extensive use
>> in excel.For more information on Array Formulas you can check the following
>> links.
>> http://www.cpearson.com/excel/arrayformulas.aspx
>>
>> http://office.microsoft.com/en-in/excel-help/introducing-array-formulas-in-excel-HA001087290.aspx
>>
>> http://www.dummies.com/how-to/content/how-to-build-an-array-formula-in-excel-2010.html
>>
>> http://spreadsheets.about.com/od/excelformulas/tp/Excel-Array-Formula-Tutorials.htm
>> http://www.mrexcel.com/articles/CSE-array-formulas-excel.php.
>>
>> There are also many other sites just google for array formulas or CSE
>>  formulas.
>>
>> Regards,
>> VijayKumar
>>
>>
>>
>> On Thu, Jul 18, 2013 at 3:36 PM, Smitha S R  wrote:
>>
>>> Hi Premor,
>>>
>>> Thanks for the support, how the {, braces appear there? and by removing
>>> that  formala is not working
>>>
>>>
>>>
>>> On Thu, Jul 18, 2013 at 1:46 PM, De Premor  wrote:
>>>
  Is like attached ?


 On 18/07/2013 14:52, Smitha S R wrote:

  Hi Team,

  Any one please help on this, as I am stuck with one report and can
 move forward only after solving this.


 On Thu, Jul 18, 2013 at 12:57 PM, Smitha S R wrote:

>Hi Team,
>
>  PFA the work book, I have to get the total values in all the column
> in another sheet wherever the same name appears.
>  Please see the attachment and help it at the earliest.
>  Assume that the values are there for 30 columns.
>
>  Thanks Smitha
>  --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like
> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
> Advice will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners
> and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google
> Groups "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send
> an email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>

  --
 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
 It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners
 and members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google
 Groups "MS EXCEL AND VBA MACROS" group.
 To unsubscribe from this group and stop receiving emails from it, send
 an email to excel-macros+unsubscr...@googlegroups.com.
 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros.
 For more options, visit ht

Re: $$Excel-Macros$$ Total of values

[Smitha S R]

Thanks a  lot Vijay,
Applying the formula suggested by Premor works. but if I insert one column
in between before values. values becomes zero.
Please help out.


On Thu, Jul 18, 2013 at 4:07 PM, P.VIJAYKUMAR  wrote:

> Respected Smitha,
>
> The braces appear by  pressing Ctrl+Shift+Enter.This converts the normal
> formal in to an array formula.Array formulas have a great and extensive use
> in excel.For more information on Array Formulas you can check the following
> links.
> http://www.cpearson.com/excel/arrayformulas.aspx
>
> http://office.microsoft.com/en-in/excel-help/introducing-array-formulas-in-excel-HA001087290.aspx
>
> http://www.dummies.com/how-to/content/how-to-build-an-array-formula-in-excel-2010.html
>
> http://spreadsheets.about.com/od/excelformulas/tp/Excel-Array-Formula-Tutorials.htm
> http://www.mrexcel.com/articles/CSE-array-formulas-excel.php.
>
> There are also many other sites just google for array formulas or CSE
>  formulas.
>
> Regards,
> VijayKumar
>
>
>
> On Thu, Jul 18, 2013 at 3:36 PM, Smitha S R  wrote:
>
>> Hi Premor,
>>
>> Thanks for the support, how the {, braces appear there? and by removing
>> that  formala is not working
>>
>>
>>
>> On Thu, Jul 18, 2013 at 1:46 PM, De Premor  wrote:
>>
>>>  Is like attached ?
>>>
>>>
>>> On 18/07/2013 14:52, Smitha S R wrote:
>>>
>>>  Hi Team,
>>>
>>>  Any one please help on this, as I am stuck with one report and can move
>>> forward only after solving this.
>>>
>>>
>>> On Thu, Jul 18, 2013 at 12:57 PM, Smitha S R wrote:
>>>
Hi Team,

  PFA the work book, I have to get the total values in all the column in
 another sheet wherever the same name appears.
  Please see the attachment and help it at the earliest.
  Assume that the values are there for 30 columns.

  Thanks Smitha
  --
 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
 It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners
 and members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google
 Groups "MS EXCEL AND VBA MACROS" group.
 To unsubscribe from this group and stop receiving emails from it, send
 an email to excel-macros+unsubscr...@googlegroups.com.
 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros.
 For more options, visit https://groups.google.com/groups/opt_out.



>>>
>>>  --
>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>>> https://www.facebook.com/discussexcel
>>>
>>> FORUM RULES
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>> 2) Don't post a question in the thread of another member.
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>> 4) Acknowledge the responses you receive, good or bad.
>>> 5) Jobs posting is not allowed.
>>> 6) Sharing copyrighted material and their links is not allowed.
>>>
>>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>>> members are not responsible for any loss.
>>> ---
>>> You received this message because you are subscribed to the Google
>>> Groups "MS EXCEL AND VBA MACROS" group.
>>> To unsubscribe from this group and stop receiving emails from it, send
>>> an email to excel-macros+unsubscr...@googlegroups.com.
>>> To post to this group, send email to excel-macros@googlegroups.com.
>>> Visit this group at http://groups.google.com/group/excel-macros.
>>> For more options, visit https://groups.google.com/groups/opt_out.
>>>
>>>
>>>
>>>
>>>  --
>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>>> https://www.facebook.com/discussexcel
>>>
>>> FORUM RULES
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>> 2) Don't post a qu

Re: $$Excel-Macros$$ Total of values

[P.VIJAYKUMAR]

Respected Smitha,

The braces appear by  pressing Ctrl+Shift+Enter.This converts the normal
formal in to an array formula.Array formulas have a great and extensive use
in excel.For more information on Array Formulas you can check the following
links.
http://www.cpearson.com/excel/arrayformulas.aspx
http://office.microsoft.com/en-in/excel-help/introducing-array-formulas-in-excel-HA001087290.aspx
http://www.dummies.com/how-to/content/how-to-build-an-array-formula-in-excel-2010.html
http://spreadsheets.about.com/od/excelformulas/tp/Excel-Array-Formula-Tutorials.htm
http://www.mrexcel.com/articles/CSE-array-formulas-excel.php.

There are also many other sites just google for array formulas or CSE
 formulas.

Regards,
VijayKumar



On Thu, Jul 18, 2013 at 3:36 PM, Smitha S R  wrote:

> Hi Premor,
>
> Thanks for the support, how the {, braces appear there? and by removing
> that  formala is not working
>
>
>
> On Thu, Jul 18, 2013 at 1:46 PM, De Premor  wrote:
>
>>  Is like attached ?
>>
>>
>> On 18/07/2013 14:52, Smitha S R wrote:
>>
>>  Hi Team,
>>
>>  Any one please help on this, as I am stuck with one report and can move
>> forward only after solving this.
>>
>>
>> On Thu, Jul 18, 2013 at 12:57 PM, Smitha S R wrote:
>>
>>>Hi Team,
>>>
>>>  PFA the work book, I have to get the total values in all the column in
>>> another sheet wherever the same name appears.
>>>  Please see the attachment and help it at the earliest.
>>>  Assume that the values are there for 30 columns.
>>>
>>>  Thanks Smitha
>>>  --
>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>>> https://www.facebook.com/discussexcel
>>>
>>> FORUM RULES
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>> 2) Don't post a question in the thread of another member.
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>> 4) Acknowledge the responses you receive, good or bad.
>>> 5) Jobs posting is not allowed.
>>> 6) Sharing copyrighted material and their links is not allowed.
>>>
>>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>>> members are not responsible for any loss.
>>> ---
>>> You received this message because you are subscribed to the Google
>>> Groups "MS EXCEL AND VBA MACROS" group.
>>> To unsubscribe from this group and stop receiving emails from it, send
>>> an email to excel-macros+unsubscr...@googlegroups.com.
>>> To post to this group, send email to excel-macros@googlegroups.com.
>>> Visit this group at http://groups.google.com/group/excel-macros.
>>> For more options, visit https://groups.google.com/groups/opt_out.
>>>
>>>
>>>
>>
>>  --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to excel-macros+unsubscr...@googlegroups.com.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/groups/opt_out.
>>
>>
>>
>>
>>  --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and

Re: $$Excel-Macros$$ Total of values

[Smitha S R]

Hi Premor,

Thanks for the support, how the {, braces appear there? and by removing
that  formala is not working



On Thu, Jul 18, 2013 at 1:46 PM, De Premor  wrote:

>  Is like attached ?
>
>
> On 18/07/2013 14:52, Smitha S R wrote:
>
>  Hi Team,
>
>  Any one please help on this, as I am stuck with one report and can move
> forward only after solving this.
>
>
> On Thu, Jul 18, 2013 at 12:57 PM, Smitha S R  wrote:
>
>>Hi Team,
>>
>>  PFA the work book, I have to get the total values in all the column in
>> another sheet wherever the same name appears.
>>  Please see the attachment and help it at the earliest.
>>  Assume that the values are there for 30 columns.
>>
>>  Thanks Smitha
>>  --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to excel-macros+unsubscr...@googlegroups.com.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/groups/opt_out.
>>
>>
>>
>
>  --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>
>
>  --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) 

Re: $$Excel-Macros$$ Total of values

[Anil Kumar]

Hi

Pfa

Anil Kumar Maurya





 From: Smitha S R 
To: excel-macros@googlegroups.com 
Sent: Thursday, 18 July 2013 12:57 PM
Subject: $$Excel-Macros$$ Total of values
 


Hi Team,

PFA the work book, I have to get the total values in all the column in another 
sheet wherever the same name appears.
Please see the attachment and help it at the earliest.
Assume that the values are there for 30 columns.

Thanks Smitha

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel
 
FORUM RULES
 
1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
 
NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.




Copy of total of values.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ Total of values

[De Premor]

Is like attached ?

On 18/07/2013 14:52, Smitha S R wrote:

Hi Team,

Any one please help on this, as I am stuck with one report and can 
move forward only after solving this.



On Thu, Jul 18, 2013 at 12:57 PM, Smitha S R > wrote:


Hi Team,

PFA the work book, I have to get the total values in all the
column in another sheet wherever the same name appears.
Please see the attachment and help it at the earliest.
Assume that the values are there for 30 columns.

Thanks Smitha
-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna

be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this
forum @ https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like
Please Help, Urgent, Need Help, Formula Problem, Code Problem, and
Need Advice will not get quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any
security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE : Don't ever post confidential data in a workbook. Forum
owners and members are not responsible for any loss.
---
You received this message because you are subscribed to the Google
Groups "MS EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it,
send an email to excel-macros+unsubscr...@googlegroups.com
.
To post to this group, send email to excel-macros@googlegroups.com
.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.



--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? 
It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel


FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like 
Please Help, Urgent, Need Help, Formula Problem, Code Problem, and 
Need Advice will not get quick attention or may not be answered.

2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security 
measure.

4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE : Don't ever post confidential data in a workbook. Forum owners 
and members are not responsible for any loss.

---
You received this message because you are subscribed to the Google 
Groups "MS EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send 
an email to excel-macros+unsubscr...@googlegroups.com.

To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.




--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group.

To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.




Copy of total of values.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ Total of values

[Smitha S R]

Hi Team,

Any one please help on this, as I am stuck with one report and can move
forward only after solving this.


On Thu, Jul 18, 2013 at 12:57 PM, Smitha S R  wrote:

> Hi Team,
>
> PFA the work book, I have to get the total values in all the column in
> another sheet wherever the same name appears.
> Please see the attachment and help it at the earliest.
> Assume that the values are there for 30 columns.
>
> Thanks Smitha
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

$$Excel-Macros$$ Total of values

[Smitha S R]

Hi Team,

PFA the work book, I have to get the total values in all the column in
another sheet wherever the same name appears.
Please see the attachment and help it at the earliest.
Assume that the values are there for 30 columns.

Thanks Smitha

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.




total of values.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet