HELP: Using IF/VLOOKUP formulas to puill and add values into single cell

[jac89]

So I am working on a mutual fund model and would like to calculate the weighted returns by sector for the stock holdings of the fund. To do this I will need to derive a formula using an IF() statement to verify the chosen sector and VLOOKUP() to pull the weighted returns of each of the stocks.

Here is simplified sample of what my sheet looks like:

AAPL Tech ret.a
YHOO Tech ret.b
JPM Finan ret.c
FEYE Tech ret.d
BAC Finan ret.e

For example, let's say I want to calculate the weighted return of my financial stocks. I would need to pull ret.c and ret.e and add them together.

So here is a breakdown of how I am looking to combine these functions:

1. Use an IF() statement which will return TRUE for all stocks included in specified sector
2. Use VLOOKUP() to pull the weighted return from each included stock
3. Add these values together in order to return the total weighted return for the specified sector

Any help and/or guidance would be much appreciated!

[hoyasaxa215]

What are the weights based on?

[daffodil11]

Assuming that data was A1:C5, then:

=SUMPRODUCT((B1:B5="Finan")*(C1:C5))

=SUMIF(B1:B5,"Finan",C1:C5)

Either of these should work.

[ConneXionLost]

If they're all in the same table then why not try the SUMIFS function instead?

[jac89]

Thanks guys! Wasn't aware of that function.