Excel crashes when formula is in worksheet

[ea223]

Hi,
My excel keeps crashing when I put this formula in: =SUMPRODUCT((TEXT($N:$N,"mmmyy")="Jul12")*($T:$T="Early"))
Can anyone help me?!
Thanks

[:) Sixthsense :)]

Try Restricting the Column Reference to range by applying the formula to the data cells alone.

=SUMPRODUCT((TEXT($N$1:$N$1000,"mmmyy")="Jul12")*($T$1:$T$1000="Early"))

Adjust the rows 1 to 1000 to your data range.

[ea223]

Hi,
this is great and has worked for most cells but for some reason is still affecting some cells?

[ea223]

It's working now, thank you!!!