ExcelBanter - Sum one column after capmaring test from teo more columns

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Sum one column after capmaring test from teo more columns (https://www.excelbanter.com/excel-worksheet-functions/8686-sum-one-column-after-capmaring-test-teo-more-columns.html)

Ashfaq

Sum one column after capmaring test from teo more columns

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.

Aladin Akyurek

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.

All times are GMT +1. The time now is 12:22 PM.