IF Function Results question

[MRLIEBS]

Hello,

I am trying to use the IF function to return the parameters of a sum
off another worksheet and don't know how. Basically I want the
following to happen. I have two worksheets in the same workbook. One
has a list of ticker symbols and the number of shares for each ticker
symbol. Some of the Tickers are the same as each portfolio might have
more than one "block" of shares of the same company. In the second
sheet I would like to "clean up" the data to show me the total number
of shares of that stock that is owned. I cannot use the sum function
because it(the share blocks) changes all the time and I would have to
go and change the parameters of the sum. I want the function (in sheet
two) to search a columm (on sheet one) and each time it finds a
specific ticker add the number of shares to my sum total on the second
worksheet's output.

Thanks!

 

[J.E. McGimpsey]

One way:

In sheet2:

A1: <ticker symbol>
B1: =SUMIF(Sheet1!A:A, A1, Sheet1!B:B)

 

[Peter Haworth]

Have you teid using a Pivot Table? They display summarized data of the form
you want. Select Pivot Table from the Data menu and follow the
instructions.
Pete