countifs count

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

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

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

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

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

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"