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

Please try the simplest one... =SUMIF(C2:C15,"<="&6500)+COUNTIFS(C2:C15,">6500")*6500 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 gre

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

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

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

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