software

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.9What 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.

quot;soilcon1quot; wrote:

gt; I have a spreadsheet that has (among many other things) three columns of data
gt; for one farm. (see abbreviated example below) One is a field identifier, the
gt; next the practice occuring on that field, and the next the size of the field.
gt; At the end of the ACRES column, there is a total of acres for the whole
gt; farm. I want a function that will identify all of the same practice and give
gt; me the total of acres for that practice so that I can find what percentage of
gt; the practice is occuring over the whole farm. For example, I want a function
gt; that will identify all the 441 practices and tell me that there are 19.8
gt; acres of that practice in total. I have tried VLOOKUP to find 441 and return
gt; values in the 3rd row, but I could not figure out how to find all the 441's
gt; and return the total of acres for that practice. Any ideas?
gt;
gt; FIELD PRACTICE ACRES
gt; a 441 2.1
gt; b 442 13.2
gt; c 443 12.8
gt; d 441 0.5
gt; e 441 17.2
gt; f 443 11.1
gt; TOTAL 56.9
gt;

That is awsome! Thanks so much, that's exactly what I needed.

quot;bpeltzerquot; wrote:

gt; What you described is what SUMIF does... =sumif(b2:b10,441,c2:c10). The
gt; second argument is what to look for, the first is where to look for it, and
gt; the third is what to add upon finding it.
gt;
gt; quot;soilcon1quot; wrote:
gt;
gt; gt; I have a spreadsheet that has (among many other things) three columns of data
gt; gt; for one farm. (see abbreviated example below) One is a field identifier, the
gt; gt; next the practice occuring on that field, and the next the size of the field.
gt; gt; At the end of the ACRES column, there is a total of acres for the whole
gt; gt; farm. I want a function that will identify all of the same practice and give
gt; gt; me the total of acres for that practice so that I can find what percentage of
gt; gt; the practice is occuring over the whole farm. For example, I want a function
gt; gt; that will identify all the 441 practices and tell me that there are 19.8
gt; gt; acres of that practice in total. I have tried VLOOKUP to find 441 and return
gt; gt; values in the 3rd row, but I could not figure out how to find all the 441's
gt; gt; and return the total of acres for that practice. Any ideas?
gt; gt;
gt; gt; FIELD PRACTICE ACRES
gt; gt; a 441 2.1
gt; gt; b 442 13.2
gt; gt; c 443 12.8
gt; gt; d 441 0.5
gt; gt; e 441 17.2
gt; gt; f 443 11.1
gt; gt; TOTAL 56.9
gt; gt;