View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Rob Rob is offline
external usenet poster
 
Posts: 718
Default Summing up rows that only have all the values

Can you help please, I need a formula to add up the values in a row, but only
if the row has a complete set of values
e.g for a row containing the following values I would expect the following
answers

20 22 20 25 21 = 108
19 20 21 20 = "blank"