IF and Sum VBA

[AlDeb]

I am using Excel 2003. From a cell in one worksheet (Team Points) I need to go to another worksheet (BS) and if certain cells i.e. D5, D6, D9, D10, D13, D14, etc. have the word "Berea" then I need to get a number from H5, H6, D9, D10, D13, D14, etc.and add them up. I hope I have worded this so someone can understand and help. I will do this in what ever way is possible. It does not have to be VBA but I though VBA might be easier.
Thanks for any help.

 

[AlphaFrog]

Can "Berea" occur in cells within column D that you are not interested in e.g. D7, D8, D11, D12 etc.?

If no, then you could use just the SUMIF function
=SUMIF('BS'!D:D, 'TEAM POINTS'!A1, 'BS'!H:H)

In this example, cell A1 on sheet TEAM POINTS has the value "Berea"

 

[AlDeb]

=SUMIF(BS!D:AF,"Berea",BS!H:AJ)

This is what is working for me at this time. I now would like to expand pulling numbers from two work sheets: 1 is BS that is in the formula above, I would like to add work sheet BD to the formula if that is possible. I appreciate any help.

 

[AlphaFrog]

Try something like this...
=SUMIF(BS!D:AF,"Berea",BS!H:AJ) + SUMIF(BD!D:AF,"Berea",BD!H:AJ)

 

[AlDeb]

Thanks Alphafrog for your help.