Summing Text

  • Thread starter Thread starter Paul
  • Start date Start date
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?
 
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
 
Bonjour, Paul

Your data in A1:B8

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

Cordialement,

Patrick.
 
Back
Top