"sony654" wrote...
Julie, Aladin, Harlan: Thankyou very much. Now when no cells are
populated with a number 0, it returns #N/A. What can I add to return
"0", if no cells are populated. Thanks for everything on this . Tom

=IF(COUNTIF(Range,"0"),<original_formula_here,0)