Excel Functions question

giovanni · Joined: 20 May 2005 Posts: 52

Hello. I am trying to build my personal commercial-invoice in Excel for a long time. I don’t know how to force some certain cell to simply sum up the prices from the above cells. Those price cells are all in one column if that matters. I figured out how to format cell to use different currency value, but this with the sum function, is a total headache. How? Thanks in advance.

alex · Joined: 17 Jan 2004 Posts: 62

You are kidding me, right? Well, it is simpler than it could be. If you are using Office 2000 or above, than this applies. Select the cell for which you want to assign a function or formula with left click, than on the function bar above, click on the autosum icon. After that, click the first cell in the column and hold the shift key. Click on the last cell after, and than release the shift key. Hit enter and you are done.

H-Desk.com - PC Security matters - Protect your PC privacy

Excel Functions question

LIFEFORM SOCIAL COMMUNITY NETWORK