Hi am trying to add a qualifier to return only the number of results that are within the J column containing CRTD and within the date range??
I think this is close but I am not getting the result I need.
=COUNTIFS('IW38'!U1:U999,">="&TODAY()-30,'IW38'!U1:U999,"<="&TODAY()-14,'IW38'!J1:J9999,"CRTD*")
This gets me a #VALUE! error.
On it's own the date range part works, and the CRTD* works, just getting them to work together is catching me??
Cheers
Heath
---------- Post added at 03:06 PM ---------- Previous post was at 02:56 PM ----------
Sorry for the double but I just figured it out, =
=COUNTIFS('IW38'!U1:U999,">="&TODAY()-30,'IW38'!U1:U999,"<="&TODAY()-14,'IW38'!J1:J999,"CRTD*") Works and
=COUNTIFS('IW38'!U1:U999,">="&TODAY()-30,'IW38'!U1:U999,"<="&TODAY()-14,'IW38'!J1:J9999,"CRTD*") does not so for some reason the J1:J9999 range was too high??
Bookmarks