Column V has dates that are manually entered. However, there might be on
occasion where the word "cancel" is typed. I have the below formula that
sums column V. How can I get it to sum without counting the text? Since it
sees the text it is giving me a #Value error.


=SUMPRODUCT(--(MONTH(Overall!V8:V1026)=MONTH(N1)),--(ISNUMBER(SEARCH(U14,Overall!D8:D1026))))