View original (French)

In a formula: "between" condition 2 values

Solved
F6GLJ Posted messages 4 Status Membre -  
F6GLJ Posted messages 4 Status Membre -
Hello, I am a beginner with Excel...

In a formula, how do I put a condition: between 42370 and 42735?

=COUNTIF('Liste QSO SAT'!B:B;between 42370 and 42735)

Thank you for your responses

Configuration: Windows / Firefox 53.0

1 réponse

Réponse 1 / 1
Fabien
 
If your condition is "between 42370 inclusive and 42735 inclusive":
=COUNTIFS('Liste QSO SAT'!B:B; ">=42370"; 'Liste QSO SAT'!B:B;
"<=42735")

If your condition is "between 42370 inclusive and 42735 exclusive":
=COUNTIFS('Liste QSO SAT'!B:B; ">=42370"; 'Liste QSO SAT'!B:B;
"<42735")
2
F6GLJ Posted messages 4 Status Membre
 
It works!

Thank you very much Fabien, I've been looking for this formula for a while!
0