Trying to build a formula that will return the value of a range of fields if the data in another range of fields is equal to specific text.

For example I want the sum of all fields in range F2:F214 if C2:C214 = "LSP"

Can anyone help? Everything I try does not work.