title: Sumif in excel rows
body: <p>I want to create a formula in excel that will sum total hours.  Here is how the sheet will look.</p>
  
  <p>row 1 2, 5, 7,1, 4, 5<br>
  row 2 X,  , X,,   , X  Total Hours</p>
  
  <p>row 3 X,  , X,X,   , X  Total Hours
  etc.</p>
  
  <p>row one indicate number of hours. </p>
  
  <p>in the total hours cell I want to add the number of hours (row 1) where the cells in row n are not blank ?</p>
  
  <p>Here is what I tried but it return 0.<br>
  =SUMIF(E1:I1,NOT="",E2:I2)</p>