SUMIF

[Guest]

hi,

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

SUMIF('OtherWorksheet'!$A:$A,$A12&D$2,'OtherWorksheet'!$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]

$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.

 

[squenson via OfficeKB.com]

This formula looks into column A of the worksheet called "OtherWorksheet". If
it find a value equals to $A12 & D$2, then it remembers the number in the
cell on the same row and in column X. At the end, it adds all these numbers
that have been found.

SUMIF is very efficient, so I can't think of a simpler way to perform this
operation, specially if the content of OtherWorksheet is changing from time
to time.