View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ken Ken is offline
external usenet poster
 
Posts: 590
Default Sumif? ... Unexpected Results?

Excel2003 ... Sumif?

=SUMIF(Unique!$F$1:$F$500,BU!$A2,Unique!$M$1:$Y$50 0)

Is only returning the SUM of Values found in Col "M"???

Above said ... the values in Range F1:F500 are NOT contiguous ...

Please provide guidance ... Thanks ... Kha