SUM.IF

[Felix]

The formula =SUM.IF(Sheet1!C:C,A1,Sheet1!B:B) gives me the right answer if
Column B is numeric.

Is there an equivalent formula if Col. B is text?

I need to compare text in one column (say C in Sheet1) with text in another
(say A1) and if there is a match, have text from column B on Sheet1 returned.

 

[Mike H]

small correction

=INDEX(Sheet1!B:B,MATCH(Sheet1!A1,Sheet1!C:C,0))

Mike

 

[Mike H]

Maybe

=INDEX(Sheet1!B:B,MATCH(Sheet1!A1,C:C,0))

Mike

 

[Bob Phillips]

=SUMPRODUCT(--(C1:C1000=A1),--B1:B1000)

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)