Hello im a noob but have a little knowledge so a really indepth explaination would be needed thx
Ok i have a spead sheet but i want to example =SUM(E17:E30) to total up my colum but in this colum i may have the number 1 in E17 and number 2 in E30 but I want the number 1 to represent let say £50 and number 2 to represent £10 and i want the =SUM to be able to convert the 1 and 2 to calculate and total up to £60 at the bottom of the colum
My question is is this possible oon a simple spred sheet or do i have to creat someothe king of sheet
thank you for any help