IF function - Counting a range of cells based on another range's value

Hi   Can anyone help with this formula at all? I would like the formula to calculate the contents in column  C if the word in column a is true and then report these on a separate worksheet. So if I...