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
>
>
Bookmarks