Help With COUNTIFS Using Greater Than Criteria

Hello,

I have a COUNTIFS formula that I am trying to get to work. It is as follows:

=COUNTIFS(Week_Created,A13,Type,"ABC",Year,2013,CreatedDate,">"&41274)

The problem I am having is with the last criteria - CreatedDate,">"&41274, When I remove the">"& and just leave the value, the formula works, counting those created on that day. However, I need all values created after that day, not on that day. I have tried specifying as ">41274" and ">"&41274 but neither work. Any suggestions on how to get the greater than criteria in the formula working?

Thanks a lot!
Amy

Hi,
I am getting a zero. I've been scratching my head about this all morning...
Thanks!

How is the range formatted that has the dates. If it is set to text it will not work. Would you be against also setting a separate cell that has the date you want to look for, so you do not have to change the formula each time? (if that question makes sense).

Hello,
I checked the formatting and everything is formatted correctly. Plus, it works when I leave it as just a number, it's only when I add the ">" that I have a problem...
Thanks!

Also, I tried putting the date in a separate cell and it didn't work that way either...

Try this

Please Login or Register  to view this content.

It is an array function so do not hit Enter hit, CTRL+SHIFT+ENTER

I get a zero using the array formula as well....

can you put a sample sheet up?

Originally Posted by daddylonglegs

Are you sure that zero isn't the correct answer?

41274 is equivalent to 31st December 2012, why do you have to check that created date is > that date if you are already checking that "Year" = 2013? Do those relate to different dates?

Didnt even think about what date that number actually was.

Unfortunately my data has protected info in it so I can't post it. However, I have been playing around with it and got it to work this way CreatedDate,">*2012". It must be a formatting thing, even though it says it is formatted as a date. Unless you have other thoughts??
Thanks for all your help with this!!

It must be a formatting thing and without seeing it wouldn't be able to figure it out. (Understand you can't post your sheet). Glad you figured it out though that works for you!

Yes, I used filters to double check all of my criteria...