Excel Count Cells if another range contains a word

Hi,    I need to add up the values from one row "IF" (looking upwards along a column) they're associated with a specific text from another row.    For example, how do I calculate the sum of value...