Summing Text

P

Paul

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?
 
R

Rick Rothstein \(MVP - VB\)

This formula should do what you want...

=SUMPRODUCT((A1:A100="d")*(B1:B100="s"))

Change both of the references to Row 100 to whatever you will eventually
need them to be.

Rick
 
Top