Help please?

[Goater10]

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.
I need help please?

Count	Days
1	3
3	6
	7
3	9
3	7
4	14

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


</tbody>

 

[wigi]

For example:

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

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

 

[Goater10]

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]

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.

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

 

[Goater10]

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</SPAN>	counter</SPAN>	dayscnt</SPAN>
Account5454</SPAN>	1</SPAN>	9</SPAN>
Account5455</SPAN>	3</SPAN>	6</SPAN>
Account5456</SPAN>	1</SPAN>	9</SPAN>
Account5457</SPAN>		9</SPAN>
Account5458</SPAN>	2</SPAN>	3</SPAN>
Account5459</SPAN>	1</SPAN>	0</SPAN>
Account5460</SPAN>		13</SPAN>

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

 

[Joe4]

[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:

">0"