0

This question already has an answer here:

I'm using this formula in my main worksheet in cell N3:

=IFERROR(INDEX(Totals!M$3:M$33,MATCH($B3,Totals!$K$3:$K$33,0)),0)

Details:

  • $B3 lists first/last names on main worksheet.
  • Totals!$K$3:$K$33 lists first/last names on "Totals" worksheet.
  • M$3:M$33 contains a numbers.

I'm looking for a way to count the numbers in column "M" if the names in column "K" match/are duplicates.

Row 3 "K" = David / M = 39

Row 4 "K" = Angela / M = 53

Row 5 "K" = Angela / M = 3

Row 6 "K" = Paul / M = 61

Row 7 "K" = Betty / M = 49

Desired result: If $B3 = Angela, then "56" is the result found in cell N3 on the main worksheet.

marked as duplicate by Excellll, Máté Juhász, nc4pk, mdpc, Steven Feb 2 '16 at 14:40

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.

0

You are looking for SUMIF()

=SUMIF(Totals!$K$3:K$33,$B3,Totals!$M$3:$M$33)

Not the answer you're looking for? Browse other questions tagged or ask your own question.