I am wondering if anyone has ever encountered a limitation on the number of
characters that are joined (concatenated) in a sumif calculation. For
example, my concatenation has a total of 20 characters (10 digit GL account
and 10 digit cost center). When doing my sumif, I am pointing to the range
that contains those concatenated cells and comparing it to the criteria
established (again a concatenation of 20 characters) to sum the amount for
all of those cells that meet that criteria. What I am getting is the same
value repetitively, because it looks like Excel is cutting off the last digit
of the GL account (not good!). We are using Excel 2007. Any help would be
greatly appreciated.
--
TD1965