Excel: Customer Accounting SUMMER


This is my raw data on sheet 1

Reference Account Date Value
INV 218736 A285 17/12/2013 14,667.60
INV 218753 B095 17/12/2013 136,840.20
INV 218778 K066 17/12/2013 17,990.00
INV 218803 N249 17/12/2013 48,780.00
INV 218824 P163 17/12/2013 35,040.00
INV 218916 C028 18/12/2013 45,220.00
INV 218917 J037 18/12/2013 45,143.00
INV 218926 J004 18/12/2013 162,000.00
INV 218944 B095 18/12/2013 307,400.00
INV 218997 C038 18/12/2013 800,000.00
This is my sheet2 where I need the summary account totals expecting B095 to add up, what formula on cell A2 AND B2 that I will copy downwards, please answer considering data will more thus read range should be to infinity
Account Value


This question generated 20 answers. To proceed to the answers, click here.

This thread is current as of January 01, 2014.


For more resources for Microsoft Excel