SUMIF Formula

[Kitty Lover]

In column D I am trying to enter a formula - if column A = column B then sum column C. In column A there are multiple #'s that are the same, but I want it to sum all cells that match column B. Is there a simeple solution, or am I not using the right formula?

 

[Aladin Akyurek]

In column D I am trying to enter a formula - if column A = column B then sum column C. In column A there are multiple #'s that are the same, but I want it to sum all cells that match column B. Is there a simeple solution, or am I not using the right formula?

Taken literally, you appear to request...

=SUMPRODUCT(--($A$2:$A$100=$B$2:$B$100),$C$2:$C$100)