FInd common data in one column then add number in adjacent column

  • Thread starter Thread starter JT
  • Start date Start date
J

JT

I suspect this is a LOOKUP formula, but I'm not sure and need some help.

Column R contains membership classifications. Column K contains
contributions. I need a formula that looks through column R for certain
classifications (example: NM09-1), then adds the values in the corresponding
cells in column K.

Appreciate any help.

JT
 
Try this...

=SUMIF(R1:R10,"NM09-1",K1:K10)

Better to use a cell to hold the criteria:

A1 = NM09-1

=SUMIF(R1:R10,A1,K1:K10)
 
Back
Top