Excel
 

I am using my Excel for a simple bookkeeping program with bill payees on the
left and months across the top. After input, I found that each cell would
not accommodate more than one amount. I also cannot figure a way for SUM
horizonally without changing everything around and have the months on the
left and payees on top...Is there a way? Please help...

Excel
 

XL is not designed to have several items in the same box (e.g. $12 $15)
have to be in separate cells.
Is this what you were trying to do? If so you could put =12+15

Excel
 

You cannot have more than one value in a single cell, try using multiple
rows / columns per entry.

To sum either vertically or horizontally use the sum function. e.g.....

=SUM(A1:A30) for a column or =SUM(A1:Z1) for a row etc.



--
Cheers
Nigel



"Kemosobe" wrote in message
...
I am using my Excel for a simple bookkeeping program with bill payees on
the
left and months across the top. After input, I found that each cell would
not accommodate more than one amount. I also cannot figure a way for SUM
horizonally without changing everything around and have the months on the
left and payees on top...Is there a way? Please help...

Excel
 

Hi

Design your app like a database!

All entries are entered on Payments or Transactions or whatever sheet, which
contains a table like
Date, Unit (or Person), Account, Sum, ...

(The Account column is used to identify different transactions and group
them (like Income: selling, services, .., and Outcome: buying, salaries,
taxes, ...)
Additionaly you may have separate sheets, where Units, Accounts etc. are
listed - you can use them as data validation list sources for main input
table.

You can have an unlimited number of different report sheets, where you can
select conditions, and all needed data is displayed through formulas from
input sheet. And you are absolutely free to design those reports as you like
am best.


Arvi Laanemets



"Kemosobe" wrote in message
...
I am using my Excel for a simple bookkeeping program with bill payees on
the
left and months across the top. After input, I found that each cell would
not accommodate more than one amount. I also cannot figure a way for SUM
horizonally without changing everything around and have the months on the
left and payees on top...Is there a way? Please help...