View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
OPSHARMA OPSHARMA is offline
external usenet poster
 
Posts: 2
Default SUM ON BASIS OF FORAMAT

Dear All,

I have exported some data From Tally in which format shows Dr & Cr now
i want total seperately of Dr and Cr ( file is attached for
reference )


19376.00 Cr
1718.00 Dr
8150.00 Cr
56180.00 Cr
133800.00 Dr
214773.00 Cr
300000.00 Dr
3879640.00 Cr
443859.00 Dr
127400.00 Cr
54628.00 Cr
1031455.00 Dr
1505733.00 Dr

Please help

Regards

O.P.Sharma