Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 21st 05, 11:22 PM posted to microsoft.public.excel.worksheet.functions
soilcon1
 
Posts: n/a
Default 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   Report Post  
Old December 21st 05, 11:26 PM posted to microsoft.public.excel.worksheet.functions
bpeltzer
 
Posts: n/a
Default 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   Report Post  
Old December 22nd 05, 12:03 AM posted to microsoft.public.excel.worksheet.functions
soilcon1
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Does excel recognise names rather than cells? Sue Excel Worksheet Functions 9 May 22nd 05 04:51 AM


All times are GMT +1. The time now is 05:48 PM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017