monies spent and monies recieved

  • Thread starter Thread starter Harold Silber
  • Start date Start date
H

Harold Silber

Good day
I have Excel 2007. What I am looking for is a simple spreadsheet which I can
use for my part time business (photography).
Monies recieved and then also a seperate column for all expenses (costs).
So that I will be able to work out profits etc etc
When I open up "NEW" ,,, there are a lot of different templates on microsoft
online but I am not sure which one to use.

Thank you
Harold
Johannesburg
South Africa
 
It doesn't sound as if you need a template, it is pretty basic what you
require.

Just use column A for a label (customer name, job id or whatever), column B
for a date, and ciolumn C for costs , D for receipts.

You can then have another sheet with the labels in column A and use
formulae such as

=SUMIF(Sheet1!A:A,A2,Sheet1!D:D)-SUMIF(Sheet1!A:A,A2,Sheet1!C:C)

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)
 
Bob Phillips said:
It doesn't sound as if you need a template, it is pretty basic what you
require.

Just use column A for a label (customer name, job id or whatever), column
B for a date, and ciolumn C for costs , D for receipts.

You can then have another sheet with the labels in column A and use
formulae such as

=SUMIF(Sheet1!A:A,A2,Sheet1!D:D)-SUMIF(Sheet1!A:A,A2,Sheet1!C:C)
Click to expand...

Can someone explain what this formula means. I mean - looking at the
spreadsheet example uploaded it looks like something I may find useful if
adapted for my own purposes. What kind of formula is this an example of so I
can look for tutorials on t'internet thingy.
 
Look at SUMIF in Help.

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)
 
Back
Top