Mark,
No it won't . . . test it.
It's a condition for example take cell B1
ISBLANK(B1:B6)=FALSE
if B1 is blank it returns FALSE (ie 0)
if B1 contains a value it returns true (ie 1)
Cell A1 * 0 = 0
Cell A1 * 1 = A1
Dan E
"Mark Bigelow" wrote in message ...
That's a great formula, except I think it will multiply A and B, which,
if I understand correctly, is not what fl wanted. A formula that might
help is:
=SUM(IF(ISBLANK(B1:B10)=FALSE, A1:A10, 0))
and then hit Ctrl-Shift-Enter.
Let me know if that doesn't work.
Mark
---
Mark Bigelow
mjbigelow at hotmail dot com
http://hm.imperialoiltx.com
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!