$a12&d$2 concatenates a couple of cells.

If gee was in $a12 and bee was in d$2, then $12&d2 would look like geebee.

The formula looks at the cells in Otherworksheet's column A for that same
concatenated string. When it finds a match, it adds the values in column X of
othersheet.

geebee wrote:

hi,

I have a worksheet in which there are lot of formulas like this:

SUMIF('OtherWorksheet'!$A:$A,$A12&D$2,'OtherWorksh eet'!$X:$X)

can someone help me interpret this? also, is there a better approach or way
to do this as opposed to having a worksheet full of these SUMIF functions?

thanks in advance,
geebee

--

Dave Peterson