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

From: Izhar To: excel-macros@googlegroups.com Sent: Sunday, May 22, 2016 8:57 PM Subject: $$Excel-Macros$$ SUM in the attachment I have two sheets i.e. JAN & FEB, in both the sheets data are same but in the FEB sheet it is more than the JAN sheet, i need a macro when I run it, th

$$Excel-Macros$$ SUM

in the attachment I have two sheets i.e. JAN & FEB, in both the sheets data are same but in the FEB sheet it is more than the JAN sheet, i need a macro when I run it, the macro sum column E,F,G, in JAN with the heading TOTAL and in the same way when I run the same macro it sum the the said column o

$$Excel-Macros$$ Sum Formula allowing for sub-totals

Hi XL2000 Have searched for this with no luck. Have a column with figures entered by user and also some sub-totals as a result of formula. How do I have a formula to add all the entered figures only, excluding the sub totals. Maybe sumif with is formula ? Thanks CharlesHarris -- Are you =E

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

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

Dear experts, I need function to sum only closing value of particular date, pls see attached file for example. Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in

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

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

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 formula that will count the number of cells in a range that contain a string (any string), but that also falls under row and column criteria. For example, if the column criteria is "3rd" and

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

gt;To all the people you can, >>As long as ever you can.” - John Wesley >>- >> From: son nguyen >>>To: excel-macros@googlegroups.com >>>Sent: Saturday, November 22, 2014 11:55 PM >>>Subject: $$Excel-Macros$$ Su

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

n,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 > *To:* excel-macros@googlegroups.com > *Sent:* Saturda

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

ple you can, As long as ever you can.” - John Wesley - > > From: son nguyen >To: excel-macros@googlegroups.com >Sent: Saturday, November 22, 2014 11:55 PM >Subject: $$Excel-Macros$$ Sum downtime for equipment wit

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

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

Dear all, I have problem when calculate total equipment downtime as there are overlap periods. For example : start time Finish time 8:00 8:20 9:00 12:00 10:00 11:30 ... start time,finish time are flexible. all of you might gi

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

$$Excel-Macros$$ Sum Product with Time

Hello, Could you please let me know what is the issue with sumproduct formula where result should be 3 but its giving as 7. Thanks in advance. Regards, Chandru -- 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 th

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

$$Excel-Macros$$ sum numbers only

Hello experts, Can you please assist me to sum numbers only in cell. Please find attachment and assist. Thanks in advance. -- 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/dis

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-Macro

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

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

xcel-macros@googlegroups.com >> *Date: *Thu, 22 Aug 2013 23:31:14 +0800 >> *To: * >> *ReplyTo: * excel-macros@googlegroups.com >> *Subject: *$$Excel-Macros$$ Sum if array for cut dates >> >> Date: 1 2 3 4 >> Amount: 100 200 300 400 >> Now

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

gt; Sandeep > Sent on my BlackBerry® from Vodafone > -- > *From: * Ali Abbas > *Sender: * excel-macros@googlegroups.com > *Date: *Thu, 22 Aug 2013 23:31:14 +0800 > *To: * > *ReplyTo: * excel-macros@googlegroups.com > *Subject: *$$Excel-Macro

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

Sender: excel-macros@googlegroups.com Date: Thu, 22 Aug 2013 23:31:14 To: Reply-To: excel-macros@googlegroups.com 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 array sum amount if date

$$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 array sum amount if date 1 to 3 then answer is 600 but if we change date scenario and mention date in cut day like sum amount if date is 2 to 4 then its answer will be 900 but how can I make th

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

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

Please help me. I have a data like details mention below. xxx a b c jan2 3 1 feb1 1 2 jan2 2 1 jan4 1 2 mar 1 3 1 I have a able xxx Jan Feb Mar a 81 1 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

$$Excel-Macros$$ Sum query

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 anyone can solve this? /Suresh -- 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) !

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

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

Dear All Experts Here I required sum formula but as per time means sum near cell value after every 5 minute.I attached sheet with all detailed Pls check it. Regards Amar -- 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

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

nt: Tue, May 21, 2013 12:59:01 PM Subject: $$Excel-Macros$$ SUM IN USERFORM Dear I have actually twelve textbox in my userform with textbox i want sum all numbers and display in a last textbox please give me code as attachments.  Awaiting... Advance thankx to experts Regards Saju-- Are you =EX

$$Excel-Macros$$ SUM IN USERFORM

DearI have actually twelve textbox in my userform with textbox i want sum all numbers and display in a last textboxplease give me code as attachments. Awaiting... Advance thankx to experts RegardsSaju -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And

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

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

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 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 w

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

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

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,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/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

$$Excel-Macros$$ Sum with maximum

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 6500. Kindly help me for formula. Regards, -- 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 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

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

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, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or

$$Excel-Macros$$ sum base on condition

Hi All, Can you help me on this example. I’m looking for excel function that will be summarized what I have to buy and I’ve bought already. I have table with requirements. On this base I’m ordering components from different suppliers. For my budget I need to know how much I’ve already paid and

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: >

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

*you mean to say that the formula should be changed automatically, whenever you create a new sheet? * -- Forwarded message -- From: Manoj Kumar Date: Wed, Nov 7, 2012 at 2:05 PM Subject: Re: $$Excel-Macros$$ Sum required from different sheet.. To: excel-macros@googlegroups.com

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

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

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 of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate th

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

@googlegroups.com Subject: $$Excel-Macros$$ Sum up of Bill of material and customer demand Dear Expert Please help me on Excel function Questions 1 I've 2 sheet (BOM and Forecast) 2 Forecast give me customer demand and BOM give m

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

Dear Expert Please help me on Excel function Questions 1 I've 2 sheet (BOM and Forecast) 2 Forecast give me customer demand and BOM give me the requirement of component part 3 Fomular requirement is need to sum up component part per day based on customer (Finish good) Can do it without

$$Excel-Macros$$ Sum on 2 conditions(one in column one in row) to another cell

Hi guys I have a report which I downloaded from crystal report to excel,, choosing the dates and then compiling the report to excel. I´m trying to do a Macro which has to go to 3 conditions and then sum to another column segunda-feira terça-feira quarta-feira quinta-feira sexta-feira segunda-

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

*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-Macros$$ sum

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

-Macros$$ sum base on 8 digits code Hi All, I need your help on this particular task. Does anyone know how to add up this value? I have bigger table that I need to add all codes started with first the same 8 digits rest of the digits are not important as this is only combination of the main first 8

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

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

Dear All, Can we get the required details? Regards, Saurabh Patel From: Saurabh Madhusudan Patel [mailto:saurabh.pa...@in.aegisglobal.com] Sent: Saturday, March 24, 2012 7:49 PM To: 'excel-macros@googlegroups.com' Subject: RE: $$Excel-Macros$$ Sum of all the random numbers

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

gt; > ** ** > > *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-Macros$$ Sum of all the random numbers generated &g

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

-Macros$$ Sum of all the random numbers generated Hi All, Need a help in attached file. There is a column were random numbers are generated. Need sum in a cell for all the random numbers which gets generated. Attached herewith the file where and all the requirements are mentioned. Regards

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

Hi All, Need a help in attached file. There is a column were random numbers are generated. Need sum in a cell for all the random numbers which gets generated. Attached herewith the file where and all the requirements are mentioned. Regards, Saurabh Patel DISCLAIMER:The information c

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

Excel > SalesAid Software > dguille...@gmail.com > > *From:* ChilExcel > *Sent:* Wednesday, March 14, 2012 3:38 PM > *To:* excel-macros@googlegroups.com > *Subject:* $$Excel-Macros$$ Sum hours weeks > > HELP !! please I need help with macro function that sum hours week . > &g

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

nd Sub Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: ChilExcel Sent: Wednesday, March 14, 2012 3:38 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Sum hours weeks HELP !! please I need help with macro function that sum hours week . attached excel file

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

End With tr = b.Row + 1 Next End Sub Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: ChilExcel Sent: Wednesday, March 14, 2012 3:38 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Sum hours weeks HELP !! please I need help with macro function

$$Excel-Macros$$ Sum hours weeks

HELP !! please I need help with macro function that sum hours week . attached excel file For this example we use in January, but I need it for all months thx all group -- Visita ; http://sites.google.com/site/chilexcel/Home Visita ; http://www.youtube.com/user/timextag41 -- FORUM RULES (98

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

$$Excel-Macros$$ Sum Product

Hi Can you please provide training material for Sum Product with few examples. -- Krishnaraddi V Madolli. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem,

  1   2   >