How simple a spreadsheet do you want?

A very simple one:

A1: Date
B1: Name
C1: Purchase
D1: Amount
format column D as Currency
F1: Adminal Total (after typing Admiral press and hold the Alt key & press
ENTER to insert a line break before you type in Total)
G1: Captain Total (line wrapped as above
H1: Balance

F2: Enter the formula:

=SUMIF(B1:B1000,"Admiral",D1:D1000)

G2: Enter the formula:
=SUMIF(B2:B1000,"Captain",D2:D1000)

Format Cell F2 & G2 as Currency

H2: Enter the formula:
=IF(F2=G2,"Balanced",IF(F2G2,"Admiral paid "&TEXT(F2-G2,"$0.00")&" more
than Captain","Captain paid "&TEXT(G2-F2,"$0.00")&" more then Admiral"))


--
HTH

Sandy
In Perth, the ancient capital of Scotland


with @tiscali.co.uk


wrote in message
...
I have MS Office 2000 on my XP Pro SP2 PC.

I am completely unfamiliar with MS Excel and would like to construct a
spreadsheet showing details of the following transactions:-

My partner and I contribute equally to the costs of running a boat ,
the expenses of which are divided eually between us.

Could anyone help me construct an expense spreadsheet in Excel showing
the two individual contributions to the costs of running the boat ,
details of those costs and and the resultant balance ( either in
credit or debit ) between each individual ?

Perhaps there are tutorials on this or details in Excel Help although
I haven't been able to find details of the latter .


B.N.