countifs date

Somebody explain me this formula please. I need your help =IF(E3=0;"";IF(COUNTIFS(G:G;G3;AD:AD;">="&AD3;AD:AD;"<="&AE3)>1;"WRONG";"OK")) <tbody> G AD AE 10000571 13/12/2018 15:30 13/12/2018 19:30 OK 10000571 13/12/2018 15:30 13/12/2018 19:30 OK 11500834 06/12/2018 15:00...

Hi, I have a spreadsheets that contains a list of incidents by date. The date therefore appears numerous times (column A) and various codes appear in the 2nd column (column B). How do I count the number of times the code in column B appears by date (column a)? Sounds simple but I have a brain...

Need a little help. I need help with my formula that needs to count every instance, during a specific time period, when either 1 of 2 columns has a text (in this case a Y) in it. Heres what I have so far: =COUNTIFS(Date,">"&'Weekly Report'!F2,Date,"<"&'Weekly Report'!G2,'Checkout...

So I'm having a weird countifs issue. I'm counting based on three variables but I'm getting a "0" result which isn't correct. I narrowed the error down to one criteria because if I take it I get results. Sheet Lead Data Upload contains data Column K is populated with dates. They are...

Hi, I am trying to count the number of times the current year is in a single column for certain people. The below is what I have so far but I keep getting 0 returned. =COUNTIFS($H25:$H500,"=WP",$J25:$J500,"="&YEAR(NOW())) Thank you in advance for the help!