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

  • Thread starter Thread starter Howard
  • Start date Start date
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
 
Howard

SUMPRODUCT() will do this. As an example:

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

Andy.
 
Back
Top