Count column b if column a contains value and column b contains another value

[cckcmiller]

l

/

lc

/

x

r2

/

ls

/

h

5

5

a

2

2

l

/

r

10

2

x

x

5

<colgroup><col span="30" width="23"></colgroup><tbody>
</tbody>

using line like above looking to count all columns that are "l" and where the next column is "/".

Completely at a loss. Count count the "l"'s and can also count the "/"'s but need to count where both are met.

 

[Marcelo Branco]

Welcome to Mr Excel

Maybe...

=SUMPRODUCT(--(A1:AC1="l"),--(B1:AD1="/"))

Hope this helps

M.

 

[cckcmiller]

Thanks Marcelo

When I add that to my equation I get the answer of "1". As you can see in the example the answer should be "2".

 

[Marcelo Branco]

Worked for me

A​

B​

C​

D​

E​

F​

G​

H​

I​

J​

K​

L​

M​

N​

O​

P​

Q​

R​

S​

T​

U​

V​

W​

X​

Y​

Z​

AA​

AB​

AC​

AD​

1​

l​

/​

lc​

/​

x​

r2​

/​

ls​

/​

h​

5​

5​

a​

2​

2​

l​

/​

r​

10​

2​

x​

x​

5​

2​

3​

Counting​

4​

2​

<tbody>
</tbody>

Formula in A4
=SUMPRODUCT(--(A1:AC1="l"),--(B1:AD1="/"))

M.

 

[cckcmiller]

Thanks again

It was my bad...my columns started in b3 and I put in c3.

 

[Marcelo Branco]

You are welcome. Thanks for the feedback.

M.