LinkBack URL
About LinkBacks
COUNTIFS is for range...
For single cell you can use:
=AND(A2>="1/1/2011",A2<"2/1/2011') + ISNUMBER(FIND("TEXTHERE", A3))
COUNTIFS is for range...
For single cell you can use:
=AND(A2>="1/1/2011",A2<"2/1/2011') + ISNUMBER(FIND("TEXTHERE", A3))
Never use Merged Cells in Excel
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks