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
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