Thread
:
Sum one column after capmaring test from teo more columns
View Single Post
#
2
Aladin Akyurek
Posts: n/a
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.
Reply With Quote