Dear Dhaval,
Your file in which u have mentioned some data is in text format. so direct
deoing sum formula will not work. firstly u should convert that text to
value by using following formula.
=value(a1) it gives u a value then do sum function .
It will work
Warm Regards,
Gawli Anil
On Mon,
ople you can,
>> As long as ever you can.” - John Wesley
>> *-
>>
>>
>> --
>> *From:* Dhaval Shah
>> *To:* excel-macros@googlegroups.com
>> *Sent:* Mon, March 18, 2013 8:12:24 AM
&g
: Mon, March 18, 2013 8:12:24 AM
Subject: $$Excel-Macros$$ Not able to do SUM
Dear Friends
me downlaod daily file from my back office pls refer NEt.xls
i m not able to do sum at the end of the amount
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:O
*Thanks Kuldeep
can i add subtotal function with below mention formula
*
On Mon, Mar 18, 2013 at 5:49 PM, Kuldeep Singh wrote:
>
> Hi Dhaval,
>
> You can use below formula.
>
> *=SUMPRODUCT(--(A1:A22))*
>
> Regards,
> Kuldeep Singh
> Info Edge India Limited (naukri.com)
> Phone.: +91-0120-484110
Hi Dhaval,
You can use below formula.
*=SUMPRODUCT(--(A1:A22))*
Regards,
Kuldeep Singh
Info Edge India Limited (naukri.com)
Phone.: +91-0120-4841100, Extn.: 2467, 9716615535
naukrikuld...@gmail.com || www.naukri.com
*Please* *Consider the environment. Please don't print this e-mail unless
you re
Dear Friends
me downlaod daily file from my back office pls refer NEt.xls
i m not able to do sum at the end of the amount
--
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 official Facebook page of this forum @
https://www.facebook.com/dis
