Sum one column after capmaring test from teo more columns

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Do you mean...

=SUMPRODUCT(--($A$2:$A$25=$B$2:$B425),$C$2:$C$25)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sum Values from different column 1
How to add values in one column based on values in another column 6
SUM - IF - AND 7
Sum of rows in different columns 3
SUMIF with criteria "<>" & "=" 4
Autogroup then sum - can it be done? 5
SUMIFS, one criteria range, multiple criteria 3
SUM question 4

Back
Top