PDA

View Full Version : response: blank lines in spreadsheet



18-10-1998, 04:45 PM
Hi Juha,
Thanks for your response.
My apologies for answering so late. I had about six messages that the mail could not be delivered. I obviously had the email address, therefore I try it this way.
Miriam uses the spreadsheet in MS. Works Version 3.0B for Windows (an oldie!)
As I have a much later version and I have Windows 95, I have not got that
problem.
In her spreadsheet she has 12 columns, one for each month.
Each row contains the turnover for each salesperson. Because some reps. don't
sell anything in a particular month or even in a year (they are only
part-timers), the cell(s) does (do)not contain any amount.
When she wants the totals (horizontal as well as vertical), wherever there are
empty cells, the result
shows a zero.
I hope my explanation makes sense to you.
Please let me know if you have a solution to her problem.
Bob Ephraim