#### Goater10

##### New Member
I have some data which below is an example of and I need to count blank below when days are <6 and between >7 and 13 and also >14.
 Count Days 1 3 3 6 7 3 9 3 7 4 14

<colgroup><col style="width: 48pt;" span="2" width="64">
<tbody>

</tbody>

### Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.

#### wigi

##### Well-known Member
For example:

=COUNTIFS(A2:A8,"",B2:B8,"<6")

Based on this, I'm sure you can work out the other combinations yourself.

#### Goater10

##### New Member
For example:

=COUNTIFS(A2:A8,"",B2:B8,"<6")

Based on this, I'm sure you can work out the other combinations yourself.

Thanks. I did work this one out from tutorials online. It doesn't seem to allow me to work out >7, <13 using the above formulae.

#### Joe4

Thanks. I did work this one out from tutorials online. It doesn't seem to allow me to work out >7, <13 using the above formulae.
Can you post the formula that you tried?
Are you trying to find the values between 7 and 13? If so, you will need to add a third condition (check), checking the same range twice, once to see if it is greater than 7 and another time to see if it is less than 13. Note that COUNTIFS can check more than two conditions (it can actually check 127 conditions!). See: COUNTIFS function - Excel

#### Goater10

##### New Member
Can you post the formula that you tried?
Are you trying to find the values between 7 and 13? If so, you will need to add a third condition (check), checking the same range twice, once to see if it is greater than 7 and another time to see if it is less than 13. Note that COUNTIFS can check more than two conditions (it can actually check 127 conditions!). See: COUNTIFS function - Excel
: Help please? Yes thanks for your help im trying to find blank between 7 and 13. Formulae used was =COUNTIFS(A2:A8,"",B2:B8,"<6,> 13")

#### Joe4

Each condition comes in pairs, the range you are checking and the condition you are checking.
So, you need to repeat your column B range, i.e.
Code:
``=COUNTIFS(A2:A8,"",B2:B8,">6",B2:B8,"<13")``

#### Goater10

##### New Member
Thats great would it be possible to use the above formulae but only count if we had a value in column a for example:

 ac no & Workevent counter dayscnt Account5454 1 9 Account5455 3 6 Account5456 1 9 Account5457 9 Account5458 2 3 Account5459 1 0 Account5460 13

<TBODY>
</TBODY><COLGROUP><COL><COL span=2></COLGROUP>

#### Joe4

Code:
``[COLOR=#333333]Thats great would it be possible to use the above formulae but only count if we had a value in column a for example:[/COLOR]``
If the value is always greater than zero, then use:
Code:
``">0"``

Replies
4
Views
177
Replies
1
Views
181
Replies
1
Views
290
Replies
1
Views
388
Replies
1
Views
541

1,195,948
Messages
6,012,475
Members
441,701
Latest member
vnkendijs

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back