How to write a formula?

[Gig88]

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

[#2 · Accepted solution]

@Gig88 

That's

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

[#3]

Thank you so much guy. My job was completed  because your suggestion. @Sergei Baklan 

[#4]

@Gig88 , you are welcome, glad to help