| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| From 2 rows or column how to find common numbers | Excel Discussion (Misc queries) | |||
| Combining worksheets with common column but different number of ro | Excel Worksheet Functions | |||
| When data match, copy adjacent value to adjacent column | Excel Worksheet Functions | |||
| Combine 2 spreadsheets w/1 common column of data, text and number | Excel Worksheet Functions | |||
| summing values from adjacent column with refrence from adjacent column | Excel Discussion (Misc queries) | |||
Linear Mode
