=SUM(IFERROR(SUBSTITUTE(E5:E14,CHAR(160),"")*1,0))
press ctrl+shift+ enter i think its already solved by ravinder
On Sat, Nov 30, 2013 at 5:50 PM, TIWARI wrote:
> Dear Sir,
> We need the sum of amount and qty in total when we are exporting file from
> erp calculation is coming only in count n
Dear Sir,
We need the sum of amount and qty in total when we are exporting file from
erp calculation is coming only in count not sum.
PLS HELP ME
--
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:
