View original (French)

In a formula: "between" condition 2 values

Solved
F6GLJ -  
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 answer

  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
    1. F6GLJ Author
      It works!

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