Cleaning up spread sheets
 

I am working with a spread sheet that has 10 columns with info including
names, addresses, type of crops grown and acres. This column was sent to me
listing each parcel, so if someone owns 10 parces with various acres for each
parcel they are listed 10 times. I am trying to put this together to for a
mailing list. So if we want to mail to someone who has over 75 acres and
they are listed on the list 10 times with lets say 25 acres per parcel they
would not be choses because the acres would show 25 not his total acres of
250. I have put the spread sheet together so that I have all the parcels
together and have been using autosum to total the parcels, then make the
change in the acres on one line and deleting the other 9 lines so he is only
listed once with the total acres. Is there a better or easier way to do
this?
--
Jan

Cleaning up spread sheets
 

Have a look in the help index for SUMIF

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Jan" wrote in message
...
I am working with a spread sheet that has 10 columns with info including
names, addresses, type of crops grown and acres. This column was sent to
me
listing each parcel, so if someone owns 10 parces with various acres for
each
parcel they are listed 10 times. I am trying to put this together to for
a
mailing list. So if we want to mail to someone who has over 75 acres and
they are listed on the list 10 times with lets say 25 acres per parcel
they
would not be choses because the acres would show 25 not his total acres of
250. I have put the spread sheet together so that I have all the parcels
together and have been using autosum to total the parcels, then make the
change in the acres on one line and deleting the other 9 lines so he is
only
listed once with the total acres. Is there a better or easier way to do
this?
--
Jan