countifs count

  1. C

    Formula to pick up data from another sheet

    Hi, I am trying to get a cell to countif from another sheet. I am on sheet 5 and trying to get data from data collection sheet. and if blank it shows nothing. For some reason, I am just getting a zero. I want to read column L from data collection and count how many of certain customers are...
  2. C

    COUNTIFS function

    For some reason, I just can't figure this out. I have a column with class grades and I need to count how many students fall between .63 and .77. I used a countifs formula, but it's not calculating it properly. I am using the same range for both counts and I think it is counting some of the...
  3. P

    Occurances within Date & Time Range - COUNTIFS

    Hi & Good Morning, I have a column (H) containing Date & Time as per the following: - 14/08/2013 06:51 14/08/2013 07:08 14/08/2013 07:11 14/08/2013 07:24 14/08/2013 08:32 15/08/2013 07:51 15/08/2013 08:51 15/08/2013 09:30 I've already got a Formula as follows to Count between Hours: -...
  4. L

    Using Countifs formula with And/Or operator (?)

    I am stuck on how to make a formula that would count how many people in Section B telework on the First Monday of the pay period. The Telework data is in 4 different columns. I am stuck on using the And/Or operators. Any ideas? Countifs(C:C,"Section B") And countifs(F:F, "Monday P1") or...
  5. L

    COUNTIFS Not equal to operator

    Good afternoon, I am having trouble with not equal to operator, "<>". I am trying to count all entries that equal "10A3" in column P and all entries that are not equal to "8888" in column K. The correct answer should be 1, instead it is giving me the total number which is 11. Here is the...
  6. J

    2 array countifs

    is there any way to make this formula work =COUNTIFS('MAIN DATA'!$BT$20:$BV$4000,A11,'MAIN DATA'!$K$20:$K$4000,"b11")) i keep getting a value error if i split the countifs it works. COUNTIFS('MAIN DATA'!$BT$20:$BV$4000,A11 COUNTIFS(MAIN DATA'!$K$20:$K$4000,"b11"

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
Back
Top