Why is this not counting using the countifs?

BadFish523

New Member
Joined
Feb 15, 2018
Messages
42
I have a large amount of raw data and have a graph to help visualize the important info. I made a couple tables to fill the charts but one of my countifs isn't working. This is my formula =COUNTIFS(Data!B2:B,"=Doug Harrison",Data!A2:A,TODAY()) but it always returns 0. B2:B is where the names are and A2:A is where the dates are. I only want the chart to display how many of that name appear for today only. Can anybody help?
 

Some videos you may like

Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
35,822
Office Version
  1. 365
  2. 2019
  3. 2016
  4. 2010
Platform
  1. Windows
  2. MacOS
Are you using Excel or Google Sheets? Your range references are not valid in Excel.
 

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
35,822
Office Version
  1. 365
  2. 2019
  3. 2016
  4. 2010
Platform
  1. Windows
  2. MacOS
I've moved the thread to the appropriate area then.

My guess would be that your criteria simply aren't being met. Either the dates in column A include times, or the name field doesn't exactly match what you have typed.
 

BadFish523

New Member
Joined
Feb 15, 2018
Messages
42

ADVERTISEMENT

I've moved the thread to the appropriate area then.

My guess would be that your criteria simply aren't being met. Either the dates in column A include times, or the name field doesn't exactly match what you have typed.

Thank you for relocating. I didnt realize there was a Sheets section on the forum. I may try formatting the dates differently but I formatted them as MM/DD/YYYY with no times. They do get put in with times which is why I reformatted the whole column. I have also check and triple checked the spelling on both. I'm baffled. Again thanks for your help.
 

BadFish523

New Member
Joined
Feb 15, 2018
Messages
42
I have also tried this with B28 being =Today() Still no luck. Any changes I could make to this one that might make it work? =countIFS(Data!A2:A,">="&B28,Data!A2:A,"<="&B28,Data!B2:B,"Doug Harrison")
 

BadFish523

New Member
Joined
Feb 15, 2018
Messages
42
I have also tried this with B28 being =Today() Still no luck. Any changes I could make to this one that might make it work? =countIFS(Data!A2:A,">="&B28,Data!A2:A,"<="&B28,Data!B2:B,"Doug Harrison")
Just FYI this is the formula I used to find the count for the week except I used B29 and B30 which adjust for the start and end of the week based on B28.
 

Aladin Akyurek

MrExcel MVP
Joined
Feb 14, 2002
Messages
85,201
I have also tried this with B28 being =Today() Still no luck. Any changes I could make to this one that might make it work? =countIFS(Data!A2:A,">="&B28,Data!A2:A,"<="&B28,Data!B2:B,"Doug Harrison")

=COUNTIFS(Data!A2:A,">="&B28,Data!A2:A,"<="&B28,Data!B2:B,"Doug Harrison")

The formula is correct, but why do we have here >= B28 and <= B28 as this is equivalent to = B28?
 

Watch MrExcel Video

Forum statistics

Threads
1,118,996
Messages
5,575,433
Members
412,664
Latest member
akilah03
Top