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

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