Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Worksheet Functions / December 2005

Tip: Looking for answers? Try searching our database.

lookup serch term and return sum of all values

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
soilcon1 - 21 Dec 2005 23:22 GMT
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
bpeltzer - 21 Dec 2005 23:26 GMT
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.

> 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
[quoted text clipped - 16 lines]
> f                         443                     11.1
>                                   TOTAL         56.9
soilcon1 - 22 Dec 2005 00:03 GMT
That is awsome!  Thanks so much, that's exactly what I needed.

> 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
[quoted text clipped - 20 lines]
> > f                         443                     11.1
> >                                   TOTAL         56.9
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.