Forums
New posts
Search forums
Members
Current visitors
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Menu
Log in
Register
Install the app
Install
Forums
Archive
Newsgroup Archive
Excel Newsgroups
Excel Misc
Counting Cells with Multiple Range Criteria (Excel 2003)
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
Reply to thread
Message
[QUOTE="Max, post: 3263667"] .. I want to count the number of rows where both Column A An alternative to try, presuming data in cols A and B are all real dates: =SUMPRODUCT((TEXT(A1:A4,"yyyy")="2005")*(TEXT(B1:B4,"yyyy")="2005")) Adapt the ranges to suit the actual extents. Any joy? hit the YES below [/QUOTE]
Verification
Post reply
Forums
Archive
Newsgroup Archive
Excel Newsgroups
Excel Misc
Counting Cells with Multiple Range Criteria (Excel 2003)
Top
