I would like to search a Column range for specific text. Then for each match I would like to have a total derived from the numeric value in another Column from the same row.

For instance: If D5 returned true then get the value of C5 and if D8 returned true add the value of C8 to it for a running total and so on.

"Thank You in Advance" = True!