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

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
 
T

T. Valko

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)
 
L

Lance

Take a look at the sumif function

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

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 cells in column based upon criteria in two others. 5
Count cells based upon criteria in other cells 13
Find and Add 3
Adding certain cells in one column 4
Place Date in One column when entry is made in another column. 3
Using ISNA on more than one column within an If Function 2
Excel Concatenate cell data from column based on criteria in adjacent column 2
TOTALING ONE COLUMN FROM INFO IN ANOTHER 2

Top