sumproduct with multiple arrays

Hi all,

I have a sumproduct formula to count how often something turns up in a specific month. That formula works fine. However, I now need to only count certain criteria in another column. My formula is

=SUMPRODUCT((TEXT('[Trial Database Final.xlsm]S4 Database Linked'!$X$1:$X$5000,"mmm-yy")="Dec-17")+0*('[Trial Database Final.xlsm]S4 Database Linked'!$Y$1:$Y$5000="Randomised"))

But, it is still counting the ones in column Y which are not 'Randomised'. Any help with this appreciated.

Thank you in advance.
Adele

Hi Adele

Try deleting the "+0" in your formula.

Edit: too late

Oh! Always the simplest thing!! Thanks both so much.