Excel Fundamentals for Data Analysis | Online Course Support

The calculation in Column G has been done, it calculates the outstanding balance for each payee by adding up the fee, arrears, and other charges from the SYS DATA sheet. Quite a lot of them are showing 0 though. The reason is the calculation is using named ranges that do not include all the data on the SYSDATA sheet. Change the Named Ranges Amount and Cust_Ref to include all the data in those columns. The balances should now be correct. What is the total balance in T7?

 
 
 
 

Similar Posts