Difficult for me!!

[leehale]

I need to take data from one sheet to another using to reference points to ensure the correct imput. I hope the example below explains.

AREA PERIOD SCORE
TOP PD1 72
MIDDLE PD1 60
TOP PD2 54
BOTTOM PD3 48

The data is exported from a data base for graphing. It is copied to a table where each area compared to each period has the score trend graphed. The problem I have is how to set a formula to look at for example: TOP - PD2 and put the score in the table in the right location.

 

[bkpchs237]

leehale,
Using the setup above where your values are in cells A1 thru C5 the following array-entered formula should work:
=SUM(($A$2:$A$5="TOP")*($B$2:$B$5="PD2")*($C$2:$C$5))

If your value of "TOP - PD2" is in a particular cell then using the following array-entered formula, assuming the cell where the value is stored to be F2, should work:
=SUM(($A$2:$A$5=LEFT($F$2,3))*($B$2:$B$5=RIGHT($F$2,3))*($C$2:$C$5))

Hope this helps.