Thread: Excel
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Nigel Nigel is offline
external usenet poster
 
Posts: 923
Default 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...