XXX Chats

updating mobile terminal

Consolidating to

If the ranges are in the same workbook but in different worksheets, you must use sheet and cell references.

You could also consolidate your debts into an unsecured personal loan, but again you’ll need a good credit rating to get the best deals.

Inside Microsoft Office 95 A Publication of The Cobb Group Published March 1997 Use this handy command on multiple ranges to calculate sums, averages, products, minimum and maximum values, and other statistical summaries.

Excel offers a number of ways to summarize information in different worksheets and workbooks.

For example, you can use the addition formula to find the average of those values.

Since the source ranges are the same size, you don't have to specifically select the entire destination range. command from the Data menu to open the dialog box shown in Figure B. Once you've selected the statistic you want Excel to calculate, you should specify the source ranges.

In the Function list box, choose the summary function you want to use. You specify individual source ranges in the Reference text box and then click the Add button to place the reference in the All References list box.

For example, what if interest rates go up, or you fall ill or lose your job?

If you can’t stop spending on credit cards, for example because you’re using them to pay household bills, this is a sign of problem debt.

If you’ve got lots of different debts and you’re struggling to keep up with repayments, you can merge them together into one loan to lower your monthly payments.

You borrow enough money to pay off all your current debts and owe money to just one lender.

Comments Consolidating to