=COUNTIFS('Master List'!$F$2:$F$2000,$K$3,'Master List'!$G$2:$G$2000,"<11/01/2011")
For some reason the above is returning a value of zero. If I change the < to = I get a value and the value is correct. I've checked and rechecked and know that I am looking at the right column of cells. What am I doing wrong!?
As always, thanks to this awesome group!
Hi Wabahoye,
I find this answers your qustion. at http://www.excel-answers.com/microso...-criteria.aspx
Same answer at http://www.excelbanter.com/showthread.php?t=257912
Let us know if that helps or if you still need help.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks