View Single Post
  #2   Report Post  
Aladin Akyurek
 
Posts: n/a
Default

Do you mean...

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

Ashfaq wrote:
Hi
I have 2 columns (A & B) of texts and one column (C) of values. I want to
sum values onlyif these are corresponding to same text in A & B.