Re: $$Excel-Macros$$ SUM

Thank you very much for your consideration and the result but if I need a formula in the same cells in which we are getting the sum of three column without the formula, is there any possibility which shows the formula in the three cells, because in this way we may press F2 and check the cell re

Re: $$Excel-Macros$$ SUM

For summing col 5,6,7 i enclose the code. verify. do it for sny no. of sheets.the code follows:Sub sum567() Dim LastRow As LongDim iRow  As LongDim iCol As IntegerLastRow = 0 For iCol = 5 To 7  iRow = Cells(65536, iCol).End(xlUp).Row  If iRow > LastRow Then LastRow = iRowNext iCol With Applicatio

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

CHeers!! On Fri, Mar 13, 2015 at 3:10 PM, Ashish Bhalara 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, Vaibhav Joshi w

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 wrote: > Hi > > Check cell D20 for formula.. > > On Fri, Mar 13, 2015 at 12:43 PM, V

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 wrote: > Hi > > Use this array formula =SUM(IF(A3:A17<>A2:A16,D2:D16,0)) > > Cheers!! > > On Thu, Mar 12, 2015 at 3:34 PM, Ashish Bhalara > wrote: > >> Dear experts, >> >> I need function to sum only closing value

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

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

Re: $$Excel-Macros$$ sum values with col/row criteria

hi can you share an excel sheet with example with little more explanation on how you arrived to result.. Cheers!! On Sat, Jan 17, 2015 at 3:09 PM, MLT wrote: > Here's one: > > In A1:A7: > 1st > 3rd > 1st > 2nd > 3rd > > In B1:E1: 3, 2, 5, 4 > > In C4: cat > In E7: dog > > I want to make a form

Re: $$Excel-Macros$$ Sum downtime for equipment with overlap periods

t; >>>>> Otherwise, I'll probably spend far too much time trying to recreate >>>>> something that doesn't apply to your situation. >>>>> >>>>> *Paul* >>>>> --------- >>>>

Re: $$Excel-Macros$$ Sum downtime for equipment with overlap periods

t;>>> >>>> >>>> *“Do all the good you can,By all the means you 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* >>>> -

Re: $$Excel-Macros$$ Sum downtime for equipment with overlap periods

t;>> 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:* son nguyen >>> *To:* excel-macros@googlegroup

Re: $$Excel-Macros$$ Sum downtime for equipment with overlap periods

good you can,By all the means you 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:* son nguyen >> *

Re: $$Excel-Macros$$ Sum downtime for equipment with overlap periods

To: excel-macros@googlegroups.com >Sent: Tuesday, November 25, 2014 11:21 PM >Subject: Re: $$Excel-Macros$$ Sum downtime for equipment with overlap periods > > > >Hi Paul, > > >I'm sorry as my past explain isn't clear for you.Please see enclosed file and >ho

Re: $$Excel-Macros$$ Sum downtime for equipment with overlap periods

--- >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> *“Do all the good you can,By all the means you can,In all the ways you >>>> can,In all the places you can,At all the times you can,To all the people >>

Re: $$Excel-Macros$$ Sum downtime for equipment with overlap periods

> >>> >>> >>> *“Do all the good you can,By all the means you 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* >>>

Re: $$Excel-Macros$$ Sum downtime for equipment with overlap periods

- John Wesley* >> ------------- >> >>*From:* son nguyen >> *To:* excel-macros@googlegroups.com >> *Sent:* Monday, November 24, 2014 11:22 PM >> *Subject:* Re: $$Excel-Macros$$ Sum downtime for equipment with overlap >> per

Re: $$Excel-Macros$$ Sum downtime for equipment with overlap periods

l the people > you can,As long as ever you can.” - John Wesley* > - > >*From:* son nguyen > *To:* excel-macros@googlegroups.com > *Sent:* Monday, November 24, 2014 11:22 PM > *Subject:* Re: $$Excel-Macros$$ Sum downtime for equipment with overlap &

Re: $$Excel-Macros$$ Sum downtime for equipment with overlap periods

he places you can,At all the times you can,To all the people > you can,As long as ever you can.” - John Wesley* > - > >*From:* son nguyen > *To:* excel-macros@googlegroups.com > *Sent:* Monday, November 24, 2014 11:22 PM > *Subject:* Re:

Re: $$Excel-Macros$$ Sum downtime for equipment with overlap periods

places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - > > From: son nguyen >To: excel-macros@googlegroups.com >Sent: Monday, November 24, 2014 11:22 PM

Re: $$Excel-Macros$$ Sum downtime for equipment with overlap periods

Mr Paul, Thank for your consider.Let me explain more : There are lots of parts within machine so i would like to list detail of their working stop time ,however when calculating downtime i only calculate actual stop time and eliminate overlap time. Son 2014-11-24 20:47 GMT+07:00 Paul Schreiner :

Re: $$Excel-Macros$$ Sum downtime for equipment with overlap periods

What do these times represent? Why would the equipment be recorded as down 9:00-12:00 AND 10:00-11:30? Is there a minimum recording increment? as in: 5 minute minimum or is it (1) minute increments? I'm considering setting up an array of increments for 24 hours and "flagging" the increment to

Re: $$Excel-Macros$$ Sum downtime for equipment with overlap periods

use data entry like 8:00AM 8:20 AM Then 8:20 AM - 8:00 AM = 0:20 Pankaj Michael On Sun, Nov 23, 2014 at 10:25 AM, son nguyen wrote: > Dear all, > > I have problem when calculate total equipment downtime as there are > overlap periods. > For example : > start time Finish time > 8:00

Re: $$Excel-Macros$$ Sum Product with Time

Cheers!! + *I did not do this for you. God is here working through me for you.* On Fri, Sep 12, 2014 at 3:58 PM, Chandra Shekar < chandrashekarb@gmail.com> wrote: > Thanks a lot > > On Fri, Sep 12, 2014 at 3:06 PM, Vaibhav Joshi wrote: > >> Chk this.. >> >> Cheers!! >> >> + >> *I di

Re: $$Excel-Macros$$ Sum Product with Time

Thanks a lot On Fri, Sep 12, 2014 at 3:06 PM, Vaibhav Joshi wrote: > Chk this.. > > Cheers!! > > + > *I did not do this for you. God is here working through me for you.* > > On Fri, Sep 12, 2014 at 12:19 PM, Chandra Shekar < > chandrashekarb@gmail.com> wrote: > >> Hello Vaibhv, >> >> It

Re: $$Excel-Macros$$ Sum Product with Time

Chk this.. Cheers!! + *I did not do this for you. God is here working through me for you.* On Fri, Sep 12, 2014 at 12:19 PM, Chandra Shekar < chandrashekarb@gmail.com> wrote: > Hello Vaibhv, > > It seems formula is wrong count should be 4 but its giving as 7. Could you > please check it

Re: $$Excel-Macros$$ Sum Product with Time

Dear Chandrashekar, Cells should not be empty. Append 0 and see . Warm Regards, Gawli Anil On Fri, Sep 12, 2014 at 12:19 PM, Chandra Shekar wrote: > Hello Vaibhv, > > It seems formula is wrong count should be 4 but its giving as 7. Could you > please check it. > > Thanks in advance. > > Regard

Re: $$Excel-Macros$$ Sum Product with Time

Hello Vaibhv, It seems formula is wrong count should be 4 but its giving as 7. Could you please check it. Thanks in advance. Regards, Chandru On Thu, Sep 11, 2014 at 8:34 PM, Vaibhav Joshi wrote: > chk this... > > > Cheers!! > > + > *I did not do this for you. God is here working through

Re: $$Excel-Macros$$ Sum Product with Time

chk this... Cheers!! + *I did not do this for you. God is here working through me for you.* On Thu, Sep 11, 2014 at 8:23 PM, Chandra Shekar < chandrashekarb@gmail.com> wrote: > Hello, > > Could you please let me know what is the issue with sumproduct formula > where result should be 3

Re: $$Excel-Macros$$ sum numbers only

try this too =SUMIF(G6:G12,">0",G6:G12)+SUMIF(G6:G12,"<0",G6:G12) On Tue, Dec 17, 2013 at 4:15 PM, priti verma wrote: > I think it is not possible with sumifs because Sumifs,sumif...etc > function does,t support array. > > > On Mon, Dec 16, 2013 at 12:17 PM, Satiqjaffar ali < > satiqjaffar...@g

Re: $$Excel-Macros$$ sum numbers only

I think it is not possible with sumifs because Sumifs,sumif...etc function does,t support array. On Mon, Dec 16, 2013 at 12:17 PM, Satiqjaffar ali wrote: > Hello Priti, > > Thanks for effort, and can you please explain the same with SUMIFS > function.? > > > On 16 December 2013 21:01, priti ver

Re: $$Excel-Macros$$ sum numbers only

Hello Priti, Thanks for effort, and can you please explain the same with SUMIFS function.? On 16 December 2013 21:01, priti verma wrote: > Hi Satiqjaffar ali, > > Please try this With Control + Shift + enter > =SUM(IFERROR(VALUE(IF(G16&F17=$E$6:$E$12&$F$6:$F$12,$G$6:$G$12,"")),"")) > > > > On

Re: $$Excel-Macros$$ sum numbers only

Hi Satiqjaffar ali, Please try this With Control + Shift + enter =SUM(IFERROR(VALUE(IF(G16&F17=$E$6:$E$12&$F$6:$F$12,$G$6:$G$12,"")),"")) On Mon, Dec 16, 2013 at 9:46 AM, Satiqjaffar ali wrote: > Hello experts, > > Can you please assist me to sum numbers only in cell. Please find > attachment

Re: $$Excel-Macros$$ Sum if array for cut dates

PFA with solution Regards, Waseem Saifi On Fri, Aug 23, 2013 at 12:36 PM, ravinder negi wrote: > PFA > > -- > *From:* Ali Abbas > *To:* excel-macros@googlegroups.com > *Sent:* Thursday, August 22, 2013 9:01 PM > > *Subject:* $$Excel-Macros$$ Sum if array for cut

Re: $$Excel-Macros$$ Sum if array for cut dates

PFA From: Ali Abbas To: excel-macros@googlegroups.com Sent: Thursday, August 22, 2013 9:01 PM Subject: $$Excel-Macros$$ Sum if array for cut dates Date:  1  2 3  4 Amount: 100 200 300 400 Now formula working. We can calculate value with arr

Re: $$Excel-Macros$$ Sum if array for cut dates

dear sir formula not work plz help. On Aug 22, 2013 5:34 PM, "Ali Abbas" wrote: > thanks brother > On Aug 22, 2013 4:14 PM, wrote: > >> ** >> You can use sumproduct also >> >> =sumproduct(--(and((a:a)>=c1,(a:a)<=c2),b:b) >> >> Assuming dates are in a row , amount are in b row. C1=smaller cutoff

Re: $$Excel-Macros$$ Sum if array for cut dates

thanks brother On Aug 22, 2013 4:14 PM, wrote: > ** > You can use sumproduct also > > =sumproduct(--(and((a:a)>=c1,(a:a)<=c2),b:b) > > Assuming dates are in a row , amount are in b row. C1=smaller cutoff date > and c2=latest date . > > Hope it works for you! :) > Sandeep > Sent on my BlackBerry®

Re: $$Excel-Macros$$ Sum if array for cut dates

You can use sumproduct also =sumproduct(--(and((a:a)>=c1,(a:a)<=c2),b:b) Assuming dates are in a row , amount are in b row. C1=smaller cutoff date and c2=latest date . Hope it works for you! :) Sandeep Sent on my BlackBerry® from Vodafone -Original Message- From: Ali Abbas Sender:

Re: $$Excel-Macros$$ Sum between two different data.

Dear Manok, Find attached herewith . Warm Regards, Gawli Anil. Thanks & Regards, Gawli Anil Narayan Software Developer, Abacus Software Services Pvt Ltd On Wed, Aug 21, 2013 at 2:30 PM, Manoj Kumar wrote: > > Please help me. > > I have a data like details mention below. > > xxx a b

Re: $$Excel-Macros$$ Sum query

=SUMIF($A$4:$A$54,H4,$B$4:$B$54) use this formula From: suresh k To: Excel group Sent: Wednesday, July 24, 2013 6:20 PM Subject: $$Excel-Macros$$ Sum query Hi All, I have attached my query regarding sum function query I know this can be solved through

Re: $$Excel-Macros$$ Sum query

You can use Sumif It's so simple ! it is simplest query I have ever found on this group. Regards, Waseem Saifi On Wed, Jul 24, 2013 at 6:51 PM, Ravinder Kumar < ravinderbhardwa...@gmail.com> wrote: > Hi > > With the help of SUM IF, you can get the result. > > For ref. PFA > > > On Wed, Jul 24,

Re: $$Excel-Macros$$ Sum query

Hi With the help of SUM IF, you can get the result. For ref. PFA On Wed, Jul 24, 2013 at 6:20 PM, suresh k wrote: > Hi All, > > I have attached my query regarding sum function query > I know this can be solved through pivot table, but I want the result in > formulaes. > Pls let me know if any

Re: $$Excel-Macros$$ Sum (After every 5 minute) formula

Dear Vabs & De Thanks Very much solution for different ways Regards Amar On Sat, Jun 15, 2013 at 5:18 PM, VBA VABZ wrote: > PFA > > In simple way > > HTH > > > On Sat, Jun 15, 2013 at 1:44 PM, amar takale wrote: > >> Dear All Experts >> Here I required sum formula but as per time means sum nea

Re: $$Excel-Macros$$ SUM IN USERFORM

I would change the name of the Total box to something like "Txt_Total" so that the textbox# doesn't get confusing. Then, I would create a function something like: Function Sum_Textboxes()     Dim sTotal As Double     sTotal = 0     If (IsNumeric(SUM.TextBox1.Value)) Then _     sTotal

Re: $$Excel-Macros$$ Sum on the basis of colour formula

Hi Noorain, Can you please share all stuff for get. function . Enjoy Team XLS On Thu, Apr 11, 2013 at 5:45 PM, NOORAIN ANSARI wrote: > Dear LK, > > Please try it.. > > =GET.CELL(63,INDIRECT("RC[-1]",)) > > > > > On Thu, Apr 11, 2013 at 4:48 PM, L.K. Modi wrote: > >>

Re: $$Excel-Macros$$ Sum on the basis of colour formula

Dear LK, Please try it.. =GET.CELL(63,INDIRECT("RC[-1]",)) On Thu, Apr 11, 2013 at 4:48 PM, L.K. Modi wrote: > Dear All > > I need formula for this particular query so please provide me any any > formula instead of macro > > > > > Dear All > > > In the given sheet i want sum on the basis of

Re: $$Excel-Macros$$ Sum on the basis of colour formula

Very good On Thu, Apr 11, 2013 at 4:00 PM, Abhishek Jain wrote: > Attached. > > > On Thu, Apr 11, 2013 at 3:20 PM, L.K. Modi wrote: > >> Dear All >> >> >> In the given sheet i want sum on the basis of colour , is there any >> formula to solve my problem >> >> >> regards >> L.K.Modi >> >> -

Re: $$Excel-Macros$$ Sum on the basis of colour formula

Attached. On Thu, Apr 11, 2013 at 3:20 PM, L.K. Modi wrote: > Dear All > > > In the given sheet i want sum on the basis of colour , is there any > formula to solve my problem > > > regards > L.K.Modi > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,D

Re: $$Excel-Macros$$ Sum with maximum

=sumif(C2:C50,"<6500",C2:C50)+countif(C2:C50,">=6500)*6500 Regards David Grugeon On 23 February 2013 20:36, Ranjeet Negi wrote: > Dear Sir, > > I have a data in Range (C2:C50). There are values. I want to sum all > value upto or equal to 6500, wherein values greater than 6500 will be > tre

Re: $$Excel-Macros$$ Sum with maximum

Hi Ranjit, Use the following formula. *=SUMIF(B2:B16,">"&6500,B2:B16)* On Sat, Feb 23, 2013 at 4:06 PM, Ranjeet Negi wrote: > Dear Sir, > > I have a data in Range (C2:C50). There are values. I want to sum all > value upto or equal to 6500, wherein values greater than 6500 will be

Re: $$Excel-Macros$$ Sum with maximum

On Saturday, February 23, 2013 8:09:18 PM UTC+5:30, अनिल नारायण गवली wrote: > > Dear Ramjit, > > Pls share a worksheet with us. > > > > Warm Regards, > Gawli Anil > > On Sat, Feb 23, 2013 at 4:06 PM, Ranjeet Negi > > > wrote: > >> Dear Sir, >> >> I have a data in Range (C2:C50). There are valu

Re: $$Excel-Macros$$ Sum with maximum

Dear Ramjit, Pls share a worksheet with us. Warm Regards, Gawli Anil On Sat, Feb 23, 2013 at 4:06 PM, Ranjeet Negi wrote: > Dear Sir, > > I have a data in Range (C2:C50). There are values. I want to sum all > value upto or equal to 6500, wherein values greater than 6500 will be > treated as

Re: $$Excel-Macros$$ Sum based on cell criteria

Pls help me on this topic. On Thu, Jan 17, 2013 at 1:17 PM, amar takale wrote: > Pls suggest formula > > -- > 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, Ur

Re: $$Excel-Macros$$ Sum required from different sheet..

ov 7, 2012 at 2:05 PM > Subject: Re: $$Excel-Macros$$ Sum required from different sheet.. > To: excel-macros@googlegroups.com > > > > Hi, > > Anybody please help me... > > > Regard > Manoj > > > On Wed, Nov 7, 2012 at 12:53 PM, Manoj Kumar wrote: >

Re: $$Excel-Macros$$ Sum required from different sheet..

Hi, Anybody please help me... Regard Manoj On Wed, Nov 7, 2012 at 12:53 PM, Manoj Kumar wrote: > Dear Expert, > > Please help me ...when I add new sheet ("3") it should be change like > that.."SUM('1:3'!B2)" > > Regard > Manoj > > -- > Join official facebook page of this forum @ > https://ww

Re: $$Excel-Macros$$ Sum() formula considering multiple values!

Vodafone >> -- >> *From: *"Mohammed Muneer" >> *Sender: *excel-...@googlegroups.com >> *Date: *Mon, 24 Sep 2012 17:19:12 +0300 >> *To: * >> *ReplyTo: *excel-...@googlegroups.com >> *Subject: *RE: $$Excel-Macros$$ Sum

Re: $$Excel-Macros$$ Sum() formula considering multiple values!

; *ReplyTo: * excel-...@googlegroups.com > *Subject: *RE: $$Excel-Macros$$ Sum() formula considering multiple values! > > *=SUMPRODUCT(--($A$3:$A$85=G5),--($B$3:$B$85=H5),--($C$3:$C$85=I5 > )*($D$3:$D$85))* [your’s] > > > > *=SUMPRODUCT(--($A$3:$A$85=F5),--($B$3:$B$85=G5),

RE: $$Excel-Macros$$ Sum() formula considering multiple values!

uld you please share your understanding for my benefit. Thanks, Joseph Sent on my BlackBerry(r) from Vodafone From: "Mohammed Muneer" Sender: excel-macros@googlegroups.com Date: Mon, 24 Sep 2012 17:19:12 +0300 To: ReplyTo: excel-macros@googlegroup

Re: $$Excel-Macros$$ Sum() formula considering multiple values!

om Subject: RE: $$Excel-Macros$$ Sum() formula considering multiple values! =SUMPRODUCT(--($A$3:$A$85=G5),--($B$3:$B$85=H5),--($C$3:$C$85=I5)*($D$3: $D$85)) [your's] =SUMPRODUCT(--($A$3:$A$85=F5),--($B$3:$B$85=G5),--($C$3:$C$85=H5)*($D$3: $D$85)) [mine] Small change is made. The onl

RE: $$Excel-Macros$$ Sum() formula considering multiple values!

=SUMPRODUCT(--($A$3:$A$85=G5),--($B$3:$B$85=H5),--($C$3:$C$85=I5)*($D$3: $D$85)) [your's] =SUMPRODUCT(--($A$3:$A$85=F5),--($B$3:$B$85=G5),--($C$3:$C$85=H5)*($D$3: $D$85)) [mine] Small change is made. The only difference as per the attachment, is F5 in place of G5 and as follows for all the

RE: $$Excel-Macros$$ Sum() formula considering multiple values!

Dear, Ashish & David thank u friends both of u. Regards, Muneer, CC -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Pl

Re: $$Excel-Macros$$ Sum base on condition in another column

thanks a lot, it was briliant.   pawel From: ashish koul To: excel-macros@googlegroups.com Sent: Tuesday, September 18, 2012 5:16 PM Subject: Re: $$Excel-Macros$$ Sum base on condition in another column SUM(SUMIF(C:C,F3:F5,D:D)) press ctrl_+shft +enter On

Re: $$Excel-Macros$$ Sum base on condition in another column

SUM(SUMIF(C:C,F3:F5,D:D)) press ctrl_+shft +enter On Tue, Sep 18, 2012 at 9:42 PM, pawel lupinski wrote: > Hi All,** > I need your help regarding to this: what I want is to sum up column D base > on condition in column N. > Regards, > Pawel > > -- > Join official facebook page o

Re: $$Excel-Macros$$ Sum up of Bill of material and customer demand

Examples and why I want cell__in sheet ___ to be ___ because__ from where Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: attapan_chainarongb...@ck-mail.com Sent: Wednesday, August 15, 2012 6:15 AM To: excel-macros@goog

Re: $$Excel-Macros$$ sum base on 8 digits code

I think Noorain's solution is the excellent among all replies. gr8 Noorain. Divaker On Thu, Jul 5, 2012 at 6:22 PM, Rajan_Verma wrote: > ** ** > > ** ** > > =SUM(--(LEFT($E$4:$E$23,8)=B4)*$F$4:$F$23) with CSE > > ** ** > > * * > > *Regards* > > *Rajan verma* > > *+91 7838100659 [IM-Gtalk]*

RE: $$Excel-Macros$$ sum base on 8 digits code

=SUM(--(LEFT($E$4:$E$23,8)=B4)*$F$4:$F$23) with CSE Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of pawel lupinski Sent: 05 July 2012 1:56 To: excel-macros@googlegroups.com Subject: $$Excel-Macr

Re: $$Excel-Macros$$ sum base on 8 digits code

Hi Noorain,   Full respect, great solution, many thanks   Pawel From: NOORAIN ANSARI To: excel-macros@googlegroups.com Sent: Thursday, July 5, 2012 4:10 AM Subject: Re: $$Excel-Macros$$ sum base on 8 digits code Hi Lupinski, Please use it.. =SUMIF($E$5

RE: $$Excel-Macros$$ Sum of all the random numbers generated

Ok You can use SUM(Number1,Number2,Number2..) Rajan. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Abhishek Jain Sent: Mar/Sat/2012 05:55 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Sum of all the random numbers generated

RE: $$Excel-Macros$$ Sum of all the random numbers generated

turday, March 24, 2012 5:56 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Sum of all the random numbers generated Understanding: Random numbers would keep generating. Question: When will the batsman be out?? On Sat, Mar 24, 2012 at 5:42 PM, Rajan_Verma wrote: Pleas

Re: $$Excel-Macros$$ Sum of all the random numbers generated

Understanding: Random numbers would keep generating. Question: When will the batsman be out?? On Sat, Mar 24, 2012 at 5:42 PM, Rajan_Verma wrote: > Please explain.. how you want to sum.. do you want to generate random > number based on a DIGIT. > > ** ** > > Rajan > > ** ** > > *From:*

RE: $$Excel-Macros$$ Sum of all the random numbers generated

Please explain.. how you want to sum.. do you want to generate random number based on a DIGIT. Rajan From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Saurabh Madhusudan Patel Sent: Mar/Sat/2012 04:11 To: excel-macros@googlegroups.com Subject: $$Excel-M

Re: $$Excel-Macros$$ Sum hours weeks

Glad to help Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: ChilExcel Sent: Thursday, March 15, 2012 5:28 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Sum hours weeks Excellent !!! dguillett1 is what I need Thank you very much for your

Re: $$Excel-Macros$$ Sum hours weeks

Excellent !!! dguillett1 is what I need Thank you very much for your attention Chilexcel 2012/3/15 dguillett1 > You may want to use this to total at the bottom of column E > > Option Explicit > Private Sub CommandButton1_Click() > > Dim tr As Integer > Dim b As Range > Dim lr As Long > tr

Re: $$Excel-Macros$$ Sum hours weeks

You may want to use this to total at the bottom of column E Option Explicit Private Sub CommandButton1_Click() Dim tr As Integer Dim b As Range Dim lr As Long tr = 2 For Each b In Columns(1).SpecialCells(xlCellTypeBlanks) With Cells(b.Row - 1, "e") .Value = Application.Sum(Range(Cells(tr, 2), Ce

Re: $$Excel-Macros$$ Sum hours weeks

See att., Option Explicit Private Sub CommandButton1_Click() Dim tr As Integer Dim b As Range tr = 2 For Each b In Columns(1).SpecialCells(xlCellTypeBlanks) With Cells(b.Row - 1, "e") .Value = Application.Sum(Range(Cells(tr, 2), Cells(b.Row - 1, 2))) .NumberFormat = "[h]:mm" End With tr = b.Row +

Re: $$Excel-Macros$$ Sum Product

Thanks a lot.. On 2/8/12, NOORAIN ANSARI wrote: > *Learn:* > >- Introduction to SUMPRODUCT > Formula >- Advanced SUMPRODUCT Formula > Examples >- Introduction

Re: $$Excel-Macros$$ Sum Product

*Learn:* - Introduction to SUMPRODUCT Formula - Advanced SUMPRODUCT Formula Examples - Introduction to SUMIFS Formula

Re: $$Excel-Macros$$ SUM Reg.

t; SalesAid Software >> dguille...@gmail.com >> >> *From:* jmothilal >> *Sent:* Saturday, November 12, 2011 9:04 AM >> *To:* excel-macros@googlegroups.com >> *Subject:* Re: $$Excel-Macros$$ SUM Reg. >> >> Dear Excel members >> >> Thanks for m

Re: $$Excel-Macros$$ SUM Reg.

A simple macro to clear the ranges Range("D6:D25,F6:G25,J6:P25,T6:W25,Z6:Z25").ClearContents Don Guillett SalesAid Software dguille...@gmail.com From: jmothilal Sent: Saturday, November 12, 2011 9:04 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ SUM Reg.

Re: $$Excel-Macros$$ SUM Reg.

=SUMIF(D2:D21,"STOCK",G2:G21) =SUMIF(D2:D21,"SALES",G2:G21) On Sat, Nov 12, 2011 at 4:43 PM, Sam Mathai Chacko wrote: > Here's a link > > > http://windowssecrets.com/forums/showthread.php/109039-sumproduct-explained-with-double-unary-operator-%282003%29 > > Do a search for Unary operators with

Re: $$Excel-Macros$$ SUM Reg.

Here's a link http://windowssecrets.com/forums/showthread.php/109039-sumproduct-explained-with-double-unary-operator-%282003%29 Do a search for Unary operators with Sumproduct, and you'll get quite a few examples Regards, Sam On Sat, Nov 12, 2011 at 4:41 PM, Sam Mathai Chacko wrote: > -- or +

Re: $$Excel-Macros$$ SUM Reg.

-- or ++ or a multiplication / division by 1, or a power by 1 etc are all working as unary operators. So for example, a boolean value TRUE/FALSE can be converted to either 1 or 0 respectively by using unary operators. And since two minuses makes a positive, it is the same as multiplying with 1 or d

Re: $$Excel-Macros$$ SUM Reg.

plz tell me that what's the meaning of* -- *in fourmula =SUMPRODUCT(*--*($D$2:$D$21=D22)*($E$2:$E$21)) On Sat, Nov 12, 2011 at 10:11 AM, jmothilal wrote: > THANKS SO MUCH , ITS WORKING FINE GET THE RESULTS. > > THANKS WITH > > MOTHILAL.J > > On Fri, Nov 11, 2011 at 10:31 PM, NOORAIN ANSARI

Re: $$Excel-Macros$$ SUM Reg.

THANKS SO MUCH , ITS WORKING FINE GET THE RESULTS. THANKS WITH MOTHILAL.J On Fri, Nov 11, 2011 at 10:31 PM, NOORAIN ANSARI wrote: > Dear Mothilal, > > try this one.. > =SUMPRODUCT(--($D$2:$D$21=D22)*($E$2:$E$21)) > On Fri, Nov 11, 2011 at 8:23 PM, jmothilal wrote: > >> DEAR EXCEL MEMBERS , >>

Re: $$Excel-Macros$$ SUM Reg.

Dear Mothilal, try this one.. =SUMPRODUCT(--($D$2:$D$21=D22)*($E$2:$E$21)) On Fri, Nov 11, 2011 at 8:23 PM, jmothilal wrote: > DEAR EXCEL MEMBERS , > > I WANT TO SUM OF SPECIFIED ROWS , HERE WITH I ATTACHED FILES. I.E STOCK > , SALES. > > THANKS WITH > > > > -- > J.Mohilal > Universal Computer

Re: $$Excel-Macros$$ SUM Reg.

Look in the help index for SUMIF =SUMIF($D$2:$D$21,"stock",$G$2:$G$21) Don Guillett SalesAid Software dguille...@gmail.com From: jmothilal Sent: Friday, November 11, 2011 8:53 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ SUM Reg. DEAR EXCEL MEMBERS , I WANT TO SUM OF SPEC

Re: $$Excel-Macros$$ SUM Reg.

You may ? like this structure better Stock Sales S.NO SHOP NO AREA SNJ10K HVB SNJ10K HVB 1 2571 12 5 12 5 2 2574 Total 12 5 12 5 Don Guillett SalesAid Software dguille...@gmail.com From: jmothilal Sent: Friday, November 11, 2011 8:53 AM

Re: $$Excel-Macros$$ SUM Reg.

Thanks for sending immediate answer. Thanks , Thanks ... Mothilal.J On Fri, Nov 11, 2011 at 8:30 PM, dguillett1 wrote: > Look in the help index for SUMIF > > =SUMIF($D$2:$D$21,"stock",$G$2:$G$21) > > Don Guillett > SalesAid Software > dguille...@gmail.com > > *From:* jmothilal > *Sent:* Fr

Re: $$Excel-Macros$$ Sum Product Sheet

Hi, Please find some more example on sum product. Regards Chethan Kumar BN On Tue, Oct 18, 2011 at 10:59 AM, ashish koul wrote: > http://www.bygsoftware.com/Excel/functions/sumproduct.htm > > http://chandoo.org/wp/2009/11/10/excel-sumproduct-formula/ > > http://www.exceluser.com/explore/sumpro

Re: $$Excel-Macros$$ Sum based on conditional formatting

Hi L K Modi, your query is not clear. Please elaborate. Kalyan On Wed, Jul 6, 2011 at 5:06 PM, ankur wrote: > *HI LK MODI > USED SUM BASED ON "COLOUR OF CELL" , MAY THIS HELP YOU > USE THIS UDF, U CAN SEE THE CODE IN MODULE > > > =ColorFunction($B$30,$B$2:$B$27,TRUE) > WHERE B30 CELL IS HAVIN

Re: $$Excel-Macros$$ Sum based on conditional formatting

use conditional format with formula =indirect("B" & row())<>"" pls find file attached. cells containg amounts out of those some > cells are coloured. > > Is there any way to coloured only those coloured cells. One way i have by > filter on the basis of colour but everytime to use that is hectic s

Re: $$Excel-Macros$$ Sum based on conditional formatting

http://akoul.blogspot.com/search/label/Function%20To%20Sum%20cells%20on%20the%20basis%20of%20font%20color http://akoul.blogspot.com/search/label/Function%20To%20Count%20cells%20on%20the%20basis%20of%20font%20color On Wed, Jul 6, 2011 at 5:06 PM, ankur wrote: > *HI LK MODI > USED SUM BASED ON

Re: $$Excel-Macros$$ Sum based on conditional formatting

*HI LK MODI USED SUM BASED ON "COLOUR OF CELL" , MAY THIS HELP YOU USE THIS UDF, U CAN SEE THE CODE IN MODULE =ColorFunction($B$30,$B$2:$B$27,TRUE) WHERE B30 CELL IS HAVING COLOUR OF THE CONDITIONAL FORMATING FILE IS ATTACHED FOR UR REFERENCE *Have A Nice Time & Enjoy Life Regards: CMA Ankur P

RE: $$Excel-Macros$$ Sum If

legroups.com Subject: Re: $$Excel-Macros$$ Sum If FOR EXAMPLE CE5 is having date =SUMIF($F$5:$BM$5,"="&CE5,$F7:$BM7) On Sun, Mar 27, 2011 at 6:29 AM, Pehrson, Dave wrote: In the sumif function shown below, I'm referencing a date: ,"=04/25/2011" =SUMIF($F$5:$BM$5,

Re: $$Excel-Macros$$ Sum If

FOR EXAMPLE CE5 is having date =SUMIF($F$5:$BM$5,"="&CE5,$F7:$BM7) On Sun, Mar 27, 2011 at 6:29 AM, Pehrson, Dave wrote: > In the sumif function shown below, I’m referencing a date: ,"=04/25/2011" > > =SUMIF($F$5:$BM$5,"=04/25/2011",$F7:$BM7) > > The Date is in cell “F5” > > Is there a way to

Re: $$Excel-Macros$$ sum duplicate value

Hi, I will also suggest to use sumif function for this purpose. Regards, Deepak Rai On Sun, Nov 14, 2010 at 2:51 PM, ratu elissa wrote: > use SUMIF Formula > > > On Sun, Nov 14, 2010 at 2:25 PM, bhavya khanna wrote: > >> Hi Everyone. >> >> Can someone explain I have data in sheet 1 The columns

Re: $$Excel-Macros$$ sum duplicate value

use SUMIF Formula On Sun, Nov 14, 2010 at 2:25 PM, bhavya khanna wrote: > Hi Everyone. > > Can someone explain I have data in sheet 1 The columns Name and Production > . Now I want to fetch data in sheet 2 . I use vlookup on the basis of Name > and fetch the production . But I have a problem.

Re: $$Excel-Macros$$ sum duplicate value

Hi Bhavya, Try usinf sumif function instead, it will help you get the sum. Sent on my BlackBerry® from Vodafone -Original Message- From: bhavya khanna Sender: excel-macros@googlegroups.com Date: Sun, 14 Nov 2010 12:55:47 To: ; Reply-To: excel-macros@googlegroups.com Subject: $$Excel-M

Re: $$Excel-Macros$$ sum duplicate value

hi use sum if function On Sun, Nov 14, 2010 at 12:55 PM, bhavya khanna wrote: > Hi Everyone. > > Can someone explain I have data in sheet 1 The columns Name and Production > . Now I want to fetch data in sheet 2 . I use vlookup on the basis of Name > and fetch the production . But I have a pro

Re: $$Excel-Macros$$ sum duplicate value

Hi, Looking at the data, the easiest you can use is SUMIF, instead of VLOOKUP Regards, Aindril On Sun, Nov 14, 2010 at 12:55 PM, bhavya khanna wrote: > Hi Everyone. > > Can someone explain I have data in sheet 1 The columns Name and Production > . Now I want to fetch data in sheet 2 . I use

Re: $$Excel-Macros$$ sum/count the number of times a name has occured

How can i get automatic update of the privo tabel? Best Regards Peter On 12 Maj, 06:31, Vikas Chouhan wrote: > two way > > 1) put formula  =COUNTIF($A42:$A$8,"Bill") > 2) Make Pivot table > > > On Tue, May 11, 2010 at 1:00 PM, nyberg75 wrote: > > Hi > > > How can i sum/count the number of

Re: $$Excel-Macros$$ sum/count the number of times a name has occured

two way 1) put formula =COUNTIF($A42:$A$8,"Bill") 2) Make Pivot table On Tue, May 11, 2010 at 1:00 PM, nyberg75 wrote: > Hi > > How can i sum/count the number of times a name has occured > > Example: > John > Bill > Gordon > Bill > Bill > Sara > Bill > John > > Result: > Bill = 4 times

  1   2   >