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

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