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

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

$$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 will be

$$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: Dear Sir,

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

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

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 ranjitsne...@gmail.comwrote: 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

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 ranjit...@gmail.comjavascript: wrote: Dear Sir, I have a data in Range (C2:C50).

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 ranjitsne...@gmail.comwrote: 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

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 ranjitsne...@gmail.com 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