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)
 

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
Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2
Is this formula possible in Excel 2003? 1
Hide columns based on row values 2

Back
Top