Simple excel file for sales vs purchases wanted

Krakkkers

Can anyone upload one or provide a link.
Just want one that totals sales and purchases

Mark_d

Just use a blank spreadsheet.  It's extremely simple to add up the numbers once they're on the spreadsheet.

the_lunatic_is_in_my_head

Sales in column A, expenses in column B. No header, no gaps in the data. 

IIRC, once all data is entered, in the next empty cell at the bottom of column A type =SUM then with the mouse click the cell above, then hold Control + Shift + Up together on the keyboard, then hit enter. This should then total the highlighted cells which will be all in column A above the cell you typed =SUM into (assuming no empty cells in between the data)

Repeat for column B. 

tizerbelle

the_lunatic_is_in_my_head said:

Sales in column A, expenses in column B. No header, no gaps in the data. 

IIRC, once all data is entered, in the next empty cell at the bottom of column A type =SUM then with the mouse click the cell above, then hold Control + Shift + Up together on the keyboard, then hit enter. This should then total the highlighted cells which will be all in column A above the cell you typed =SUM into (assuming no empty cells in between the data)

Repeat for column B. 

Or with the cursor in the cell below your last entry, just use the AutoSum button from the ribbon (symbol looks kind of like an M on it's side - if it had toppled over to the left)

Krakkkers

I watched a youtube video and then knocked up a basic spreadsheet that does what i want.