How can I count line entries based on meeting criteria for 2 separate columns?

Originally Posted by bebo021999

Have you tried:
=SUMPRODUCT(('Article List'!$B$4:$B$999="Unassigned Pre-Publish")*(MONTH('Article List'!D4:D10000)=4))
yet?

Thank you! Worked like a charm.
Much appreciated.