count meets two criteria

  1. D

    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. V

    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. K

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

This Week's Hot Topics

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