SUMIF mets text requirment a given number of cells to the left

[Howard]

I am trying to set up a formula that will sum a column of
numbers, but only the numbers that match a given text that
would be a specified number of cells to the left

 

[Andy B]

Howard

SUMPRODUCT() will do this. As an example:

=SUMPRODUCT((C2:C200)*(A2:A200="text"))

Andy.