On Thu, 11 Dec 2008 04:43:16 -0800 (PST), Jarek Kujawa
wrote:

one way:

=SUM(IF(ISEMPTY(A1:A100),0,A1:A100))

this is an array-formula so CTRL+SHIFT+ENTER it instead of simply
using ENTER



How would the result of this differ from the normally entered:

=sum(a1:a100)

???
--ron