Gathering and adding data from different rows

[rxwillow]

Hi all,

I run a report at work every day that tells me how many shares of a
company have been sold and from what year these shares were granted to
the participant. The year and the amount of shares are on different
lines. For instance, the year would be on D5 and the share amount would
be on D10. This is a daily function and the data changes every day. I am
required to manually scan these reports and add up the shares for each
year separately. I have to separate the amounts for 2003, 1997 and
1996.

I want to create a spreadsheeet that I can dump this data into and have
the spreadsheet find the years and add up the share amounts for those
specific transactions. Is there a tutorial or anyone that can help me
with this. Like I said, the data is always in column D. The year and
the share amounts are always 5 rows apart from each other. Any help
would be greatly appreciated.

I could also supply an example of the report if needed.

Thanks,
Joel

 

[Guest]

Hi

This sounds like a job for a Pivot Table. For an introduction, have a read
of this:
http://www.cpearson.com/excel/pivots.htm
It's really easy to do!

Hope this helps.
Andy.

 

[JAVB]

If I understand your explanation correctly, you have different types o
data in the same column (D). Pivot tables must have the same type o
data in the same column. Do you have column headings or row headings
or neither? You might try oganizing your data in columns such as
Shares in one column, years in another column, company in a thir
column, participant in a 4th column. etc. A sample of your sheet woul
be helpful if the above is not clear.

JAV