Formula

Sue van Niekerk

=COUNTIF({Survey Intake }, <5>2

Hey Guys i am trying to do a formaula that will count figures in a column but need to count all numbers between 5 and 2

so all numbers 3 and 4

Bassam Khalil

Hi @Sue van Niekerk 

Hope you are fine, please try the following formula:

=COUNTIFS({Survey Intake }, AND(@cell < 5, @cell > 2))

Bassam Khalil

Hi @Sue van Niekerk 

Hope you are fine, please try the following formula:

=COUNTIFS({Survey Intake }, AND(@cell < 5, @cell > 2))

Sue van Niekerk

HI Bassam,

Thank you that worked perfectly !!! can I ask you to explain the formula so I can understand why it has to be done like that.... that way if I understand why then I will be able to replicate it in another sheet requirement in the future

Bassam Khalil

@Sue van Niekerk

The @cell Function is to check the range cell by cell, and we use AND function to cover your criteria.

you are welcome if you need any more help.