Summing Text

Giganews Newsgroups
Subject: Summing Text
Posted by:  Paul (Msr…@TPx12.com)
Date: Sun, 13 Jul 2008

I have two columns of text

d    s
d    r
t    s
p  s
p  r
t    r
t    r
d  s

How do I write a formula to find out how many instances there are of d
in columna A that correspond to s in Column B?  Should be two.

Is that sumprouct or sumif?

Replies