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!