# count meets two criteria

1. ### Countif using multiple criteria

Hi I am trying to use a countif based against using the following criteria where the value of column falls between the bands and then how many people fall within that Band Band 1 0-4999.99 Band 2 5000-9999.99 etc and then to find out how many times the numbers 40 42 61 65 within the 2000...
2. ### countif problem

I have data where by the date range i want it to count up all the times between 2 min and 5 min so i have the following formula: COUNT(IF(SACRN!\$E:\$E>=DATE(109,6,15),IF(SACRN!\$I:\$I,{">=0.00138888888",">=0.00347222222"})*{1,-1})) But i only end up with value of 1. Can someone please let me know...
3. ### formula to count number of type per person

Here is an example of my report: I need to be able to formulate to count how many types (400mgs, data8mf, data8mg, etc) go to each rep (caitlin wolf, little bo-tique, amee lundberg, etc). Can you help me formulate? <TABLE style="WIDTH: 581pt; BORDER-COLLAPSE: collapse" cellSpacing=0...

### 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