Forum Discussion

Copper Contributor

May 10, 2020

Solved

How to write a formula?

How can I write a formula if I want to countif Range B7:B30 contain value that >= cell A7 and < cell A6 ?

Formulas and Functions

SergeiBaklan
May 10, 2020
Gig88

That's

=COUNTIFS(B7:B30,">="&A7,B7:B30,"<"&A6)

3 Replies

SergeiBaklan
Diamond Contributor
May 10, 2020
Gig88

That's

=COUNTIFS(B7:B30,">="&A7,B7:B30,"<"&A6)
- Gig88
  Copper Contributor
  May 14, 2020
  Thank you so much guy. My job was completed because your suggestion. SergeiBaklan
  - SergeiBaklan
    Diamond Contributor
    May 15, 2020
    Gig88 , you are welcome, glad to help