=SUMIF(Unique!$F$1:$F$500,BU!$A2,Unique!$M$1:$Y$50 0)
Yes, although Excel accepts the above expression as-is, in actuality only
the leftmost col M is operative, as you found out
Try using sumproduct for multi-cols:
=SUMPRODUCT((Unique!$F$1:$F$500=BU!$A2)*Unique!$M$ 1:$Y$500)
Above lightly tested ok. If it works, click the YES below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
"Ken" wrote:
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