| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
