View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jeff Jeff is offline
external usenet poster
 
Posts: 921
Default If Statement / Array

Hello,

I have data in columns A, B, and C. In column D, I would like a formula
that sums the contents of A1:C1, but only if none of the cells contains a
zero. In other words, if all the cells are greater than zero, return the
sum. If one of the cells has a figure of zero, return zero.

Help?! TIA