Summing Text

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

 

[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

 

[Paul]

Thanks guys.

Bonjour, Paul

Your data in A1:B8

=SOMMEPRODUCT((A1:A8="d")*(B1:B8="s"))
gives 2.

Cordialement,

Patrick.