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

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 explana

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

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

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

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

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

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

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

=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

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

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 D

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

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.VIJAYKUMA

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

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 colu

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

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=Ae7

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

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 conve

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

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

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

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 wi

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

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

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

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 boo

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

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 app

$$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?