Help please?

Goater10

New Member
Joined
Mar 22, 2013
Messages
14
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?
CountDays
13
36
7
39
37
414



<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
Joined
Jul 10, 2006
Messages
7,964
Office Version
  1. 365
Platform
  1. Windows
  2. Mobile
  3. Web
For example:

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

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

Goater10

New Member
Joined
Mar 22, 2013
Messages
14
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.
 
Upvote 0

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
68,098
Office Version
  1. 365
Platform
  1. Windows
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
 
Upvote 0

Goater10

New Member
Joined
Mar 22, 2013
Messages
14
ADVERTISEMENT
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")
 
Upvote 0

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
68,098
Office Version
  1. 365
Platform
  1. Windows
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")
 
Upvote 0

Goater10

New Member
Joined
Mar 22, 2013
Messages
14
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>
 
Upvote 0

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
68,098
Office Version
  1. 365
Platform
  1. Windows
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"
 
Upvote 0

Forum statistics

Threads
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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top