Excel Formulas

Hi Matt
Thank you for your questions

To use the sum function to add non adjacent (Scattered) ranges.

Select the cell where the formula is to go, and insert a function from the insert menu. Type sum in the search box and press enter. You will then be prompted to enter a cell or range. Enter the first cell. Once done another range box will appear below; enter the next range in that box. Repeat until all cells have been entered and click OK.

To place the pound/euro sign, select the relevant cells, and then click on format cells from the format menu. Choose currency and then select the relevant currency symbol from the combo box.

To print the data on one page, simply go to page set up on the file menu, and select the option for fitting the sheet to one page.

Hope this helps

Regards

Stephen