Have you tried a Pivot Table or Subtotals?
Data Text to Column Space Finish
Insert a row on the top. Data Pivot Table Finish
If you use a subtotal, sort the data Data Subtotal Sum Add subtotal
to...Ok

HTH,
Ryan---

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Loop" wrote:

Also I need to compare the dinal data with the data on another sheet
(the same accounts but different totals) to get difference.

Thanks,