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

H

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
 
A

Andy B

Howard

SUMPRODUCT() will do this. As an example:

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

Andy.
 
Top