View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
tallyman00
 
Posts: n/a
Default sumif wrong result


I am trying to sum cells across a row, if the corresponding cell in
another row, the same column, has an “A”. I am getting incorrect
results. Why? Here is my formula: =SUMIF($C$4:$N$4,"A",C9:N9)

Thanks


--
tallyman00
------------------------------------------------------------------------
tallyman00's Profile: http://www.hightechtalks.com/m617
View this thread: http://www.hightechtalks.com/t2318593