Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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... |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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... |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|