Forum Discussion

Gig88's avatar
Gig88
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 ?
excel
Formulas and Functions
training
  • SergeiBaklan's avatar
    SergeiBaklan
    May 10, 2020

    Gig88 

    That's

    =COUNTIFS(B7:B30,">="&A7,B7:B30,"<"&A6)
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
May 10, 2020

Gig88 

That's

=COUNTIFS(B7:B30,">="&A7,B7:B30,"<"&A6)
  • Gig88's avatar
    Gig88
    Copper Contributor
    May 14, 2020

    Thank you so much guy. My job was completed  because your suggestion. SergeiBaklan 

    • SergeiBaklan's avatar
      SergeiBaklan
      Diamond Contributor
      May 15, 2020

      Gig88 , you are welcome, glad to help