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
*Thanks Kuldeep
can i add subtotal function with below mention formula
*
On Mon, Mar 18, 2013 at 5:49 PM, Kuldeep Singh naukrikuld...@gmail.comwrote:
Hi Dhaval,
You can use below formula.
*=SUMPRODUCT(--(A1:A22))*
Regards,
Kuldeep Singh
Info Edge India Limited (naukri.com)
Phone.:
The problem is:
even though the cells contain only numeric values,
when you opened the downloaded file, the cells were read as TEXT.
Changing the cell/column format to numeric does not change the existing values.
If you select the entire column and replace . with .
Excel will re-evaluate the
Thanks Dear
still i m not getting what i want pls refer sheet
On Mon, Mar 18, 2013 at 5:59 PM, Kuldeep Singh naukrikuld...@gmail.comwrote:
Hi Dhaval,
You can use below formula:
*=SUM(INT(A1:A22)) With Ctrl + Shift + Enter.*
Regards,
Kuldeep Singh
Info Edge India Limited (naukri.com)
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