Sum numbers only; no text

[Guest]

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!D81026))))

 

[Biff]

Hi!

That really throws a monkey wrench into the mix!

Try this:

=SUMPRODUCT(--(TEXT(Overall!V8:V1026,"mmm")=TEXT(N1,"mmm")),--(ISNUMBER(SEARCH(U14,Overall!D81026))))

Biff

 

[Guest]

Yeah. You need to watch for those monkey wrenches. They hurt.

That was the formula I needed. Thanks again.