Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
lookup serch term and return sum of all values
I have a spreadsheet that has (among many other things) three columns of data
for one farm. (see abbreviated example below) One is a field identifier, the next the practice occuring on that field, and the next the size of the field. At the end of the ACRES column, there is a total of acres for the whole farm. I want a function that will identify all of the same practice and give me the total of acres for that practice so that I can find what percentage of the practice is occuring over the whole farm. For example, I want a function that will identify all the 441 practices and tell me that there are 19.8 acres of that practice in total. I have tried VLOOKUP to find 441 and return values in the 3rd row, but I could not figure out how to find all the 441's and return the total of acres for that practice. Any ideas? FIELD PRACTICE ACRES a 441 2.1 b 442 13.2 c 443 12.8 d 441 0.5 e 441 17.2 f 443 11.1 TOTAL 56.9 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
lookup serch term and return sum of all values
What you described is what SUMIF does... =sumif(b2:b10,441,c2:c10). The
second argument is what to look for, the first is where to look for it, and the third is what to add upon finding it. "soilcon1" wrote: I have a spreadsheet that has (among many other things) three columns of data for one farm. (see abbreviated example below) One is a field identifier, the next the practice occuring on that field, and the next the size of the field. At the end of the ACRES column, there is a total of acres for the whole farm. I want a function that will identify all of the same practice and give me the total of acres for that practice so that I can find what percentage of the practice is occuring over the whole farm. For example, I want a function that will identify all the 441 practices and tell me that there are 19.8 acres of that practice in total. I have tried VLOOKUP to find 441 and return values in the 3rd row, but I could not figure out how to find all the 441's and return the total of acres for that practice. Any ideas? FIELD PRACTICE ACRES a 441 2.1 b 442 13.2 c 443 12.8 d 441 0.5 e 441 17.2 f 443 11.1 TOTAL 56.9 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
lookup serch term and return sum of all values
That is awsome! Thanks so much, that's exactly what I needed.
"bpeltzer" wrote: What you described is what SUMIF does... =sumif(b2:b10,441,c2:c10). The second argument is what to look for, the first is where to look for it, and the third is what to add upon finding it. "soilcon1" wrote: I have a spreadsheet that has (among many other things) three columns of data for one farm. (see abbreviated example below) One is a field identifier, the next the practice occuring on that field, and the next the size of the field. At the end of the ACRES column, there is a total of acres for the whole farm. I want a function that will identify all of the same practice and give me the total of acres for that practice so that I can find what percentage of the practice is occuring over the whole farm. For example, I want a function that will identify all the 441 practices and tell me that there are 19.8 acres of that practice in total. I have tried VLOOKUP to find 441 and return values in the 3rd row, but I could not figure out how to find all the 441's and return the total of acres for that practice. Any ideas? FIELD PRACTICE ACRES a 441 2.1 b 442 13.2 c 443 12.8 d 441 0.5 e 441 17.2 f 443 11.1 TOTAL 56.9 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Does excel recognise names rather than cells? | Excel Worksheet Functions |