Folks,
I have been using the CONCATENATE function to turn SUMIF into a relative adress capable tool. It turns the function into a pretty useful tool but it seems cumbersome to me.
Any one know a smarter way around this?
Thanks.
Francois.

Ex.: sumif("b2:b200",concatenate("=",c2),"c2:c200")