I have a bunch of criteria that doesn't seem to be working.
The > represents dates. I want to say countif the DATE within the range is more than that cell.
Please Login or Register to view this content.
Someone have a better way to do this given how much criteria?
Thanks!
Change ">'Sheet Count'!J19" to ">"&'Sheet Count'!J19
Don't just use the answers provided for you. Try to understand how it works by reverse engineering or asking about it.
Please mark the thread as [SOLVED] (Thread Tools->Mark thread as Solved) when answered.
If you're happy with an answer given, please click the * under the person's name to boost their reputation.
Also need to adjust the last part too,,,,
=COUNTIFS('Sheet Data'!L:L,"Sales",'Sheet Data'!P:P,">"&'Sheet Count'!J19,'Employee Data'!W:W,"<>"&Budgeted)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
@Fdibbins - unless "Budgeted" is a named range (which I assumed it wasn't) the way he had it would be fine to filter out the word "budgeted".
Craig, oops yes you are totally correct, apologies - it was a bit late when I replied.
This is a small pet pieve of mine.
You only have to use the & syntax when:
You're using the < and/or > operators.
AND
The criteria value is a Cell Reference or result of another function.
It is NOT required for the = operator or with a manually entered text value.
That is the default operation of the xxxIFs functions.
I cringe when I see
"="&"sometext"
"="&A1
Jonmo, your point is well made and I agree totally
However, unless I am missing something, I dont see any of your "dont use" commands? (or were you just making a comment?)
It was just a comment. And I didn't meant to hijack the thread. Sorry.
I usually don't say "don't do that" because it's technically not wrong. It does work.
But in my suggested solutions, I'll remove that syntax
No, I fully understand, and again, fully agree (I have "adjusted" that myself a few times too). I dont consider your observation a hijack, it is a valid contribution
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks