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