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 Worksheets
Countif function based on multiple criteria
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
Reply to thread
Message
[QUOTE="JMay, post: 3450799"] Try: =SUMPRODUCT(($B$1:$B$6>=$A$1)*($B$1:$B$6<=EOMONTH($A$1,0))*($C$1:$C$6=$J$2)* ($D$1:$D$6=$J$3)*($E$1:$E$6)) In Cell J2 enter the desired Column C Code and in J3 enter the desired Column D Code. HTH [/QUOTE]
Verification
Post reply
Forums
Archive
Newsgroup Archive
Excel Newsgroups
Excel Worksheets
Countif function based on multiple criteria
Top
