if, and, then formula
 

I'm trying to make a formula such that if a column has alphabetical digits
[E,I, M,P,...] and the column beside it has numerical digits [5, 6, 8...], I
can relate the number of times I matches with 6. I cannot do just a simple
countif and subtraction formula as sometimes the 6 matches with E. I tried:
=if(E21:e25,"I")and(D21:d25,"6")then(countif(e21:e 25,"I")) but that only
results in an error. However, that might give an idea of what I'm looking
for.
Thanks!

if, and, then formula
 

=Sumproduct(--(E21:E25)="E"),--(D21:D25=6))

"Booklover32" wrote:

I'm trying to make a formula such that if a column has alphabetical digits
[E,I, M,P,...] and the column beside it has numerical digits [5, 6, 8...], I
can relate the number of times I matches with 6. I cannot do just a simple
countif and subtraction formula as sometimes the 6 matches with E. I tried:
=if(E21:e25,"I")and(D21:d25,"6")then(countif(e21:e 25,"I")) but that only
results in an error. However, that might give an idea of what I'm looking
for.
Thanks!

if, and, then formula
 

Should be...

=Sumproduct(--(E21:E25="E"),--(D21:D25=6))


"Toppers" wrote:

=Sumproduct(--(E21:E25)="E"),--(D21:D25=6))

"Booklover32" wrote:

I'm trying to make a formula such that if a column has alphabetical digits
[E,I, M,P,...] and the column beside it has numerical digits [5, 6, 8...], I
can relate the number of times I matches with 6. I cannot do just a simple
countif and subtraction formula as sometimes the 6 matches with E. I tried:
=if(E21:e25,"I")and(D21:d25,"6")then(countif(e21:e 25,"I")) but that only
results in an error. However, that might give an idea of what I'm looking
for.
Thanks!