Hi.. Please see the following data(actul file is too long), I need the data in the excell file coloumn E and F . Please suggest and show me any of the appropriate formula (A ) (B) (C) (D) (E ) (F ) Date Cash Sale Card Sale Credit Sale Collection TOTAL CASH SALE FROM 01.11.2011 TO 09.11.2011 TOTAL CARD SALE FROM 01.11.2011 TO 09.11.2011 01.11.2011 67,777.736 21,602.200 872.465 02.11.2011 73,794.656 24,298.670 1,859.655 03.11.2011 107,874.198 39,601.380 743.150 04.11.2011 104,378.004 38,247.890 867.945 05.11.2011 94,406.361 31,794.010 53.640 06.11.2011 22,974.315 5,698.940 8.465 07.11.2011 44,364.067 11,839.140 459.220