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
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
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).
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
=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