If I am reading the request correctly you would only have one result where
1236 = 1236. In that case, you would need an IF formula. =IF(B4=A4,C4,0).
This states that if the amount in column B equals column A take the column C
value. If it does not use 0 value. You can change 0 value to anything you
would like, if you would like words replace 0 with "words"

"japorms" wrote:


I need to sum different criterias. I have three columns. A, B, and C.

Sample

1234 1235 20
1235 1231 15
1236 1236 10

I need the formula to match the data in column B to column A. If it
match, the formula must total the amount in column C.

I hope someone can help me with this.

Thanks in advance!


--
japorms
------------------------------------------------------------------------
japorms's Profile: http://www.excelforum.com/member.php...fo&userid=6544
View this thread: http://www.excelforum.com/showthread...hreadid=537219