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

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

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

What corresponding cells? HTH Otto

"JT" wrote in message
...
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

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

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)

--
Biff
Microsoft Excel MVP


"JT" wrote in message
...
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

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

Take a look at the sumif function

sumif(r1:r100,a1,k1:k100)
assuming a1 contains NM09-1


"JT" wrote:

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