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
Pls see the solution in attached sheet
Nitin
On Saturday, February 23, 2013 1:14:46 PM UTC+5:30, satyas wrote:
Hi Experts,
Just need to compare two columns by last name . Will appreciate if you can
help me for this.
Satya.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do
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 will be
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:
Dear Sir,
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 SUMIF
Hi
I want to link multiple data in row to column, but when you use transpose
function the links are not working need to past special in value term
Sample Sheet attached
Please advice
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join
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
10 matches
Mail list logo