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

2013-02-23 Thread David Grugeon
=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

2013-02-23 Thread >>Excel Beginner<
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

2013-02-23 Thread Nitin Gupta
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

2013-02-23 Thread अनिल नारायण गवली
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$$ DATA LINKAGE PROBLEM

2013-02-23 Thread Nitin Gupta
Hi I want to link multiple data in row to column, but when you use transpose function the links are not working need to past special in value term Sample Sheet attached Please advice -- 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 officia

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

2013-02-23 Thread Nitin Gupta
Solution in Single Step On Saturday, February 23, 2013 5:01:30 PM UTC+5:30, Ranjeet Negi wrote: > > Thanks, but is it possible to make one formula instead of two step. > > On Saturday, 23 February 2013 16:45:09 UTC+5:30, Nitin Gupta wrote: >> >> I see the answer in 2 steps, as attached >> >> IF &

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

2013-02-23 Thread Ranjeet Negi
Thanks, but is it possible to make one formula instead of two step. On Saturday, 23 February 2013 16:45:09 UTC+5:30, Nitin Gupta wrote: > > I see the answer in 2 steps, as attached > > IF & SUMIF > > Regards > Nitin > > > > On Saturday, February 23, 2013 4:06:15 PM UTC+5:30, Ranjeet Negi wrote: >>

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

2013-02-23 Thread Nitin Gupta
I see the answer in 2 steps, as attached IF & SUMIF Regards Nitin On Saturday, February 23, 2013 4:06:15 PM UTC+5:30, 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 wi

$$Excel-Macros$$ Re: Compare two text columns by last name

2013-02-23 Thread Nitin Gupta
Pls see the solution in attached sheet Nitin On Saturday, February 23, 2013 1:14:46 PM UTC+5:30, satyas wrote: > > > Hi Experts, > > Just need to compare two columns by last name . Will appreciate if you can > help me for this. > > Satya. > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? A

$$Excel-Macros$$ Sum with maximum

2013-02-23 Thread Ranjeet Negi
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