Agreed, RD on the point of any empty cells within the range becoming zero,
albeit this won't affect the OP's intent to sum. The subtle point about the
multiply option is that by entering a "1" into an "empty" cell, that in
itself ensures that the "empty" cell will contain a: 1, and not an invisible
whitespace(s) <g. I use both methods.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads: 16,200, Files: 354, Subscribers: 53
xdemechanik
---
"RagDyer" wrote in message
...
Max, FWIW
One point about the "multiply" option as opposed to the "add" option.

If some of the cells are not contiguous, with the "add" option, you could
select an all encompassing block of cells, with an easy single selection,
that could go beyond the cells in question, and include empty and/or blank
surrounding cells.

If you tried this with the "multiply" option, those empty cells would
become filled with 0's.