Sum numbers only; no text
 

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

Sum numbers only; no text
 

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!D8:D1026))))

Biff

"roy.okinawa" wrote in message
...
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))))

Sum numbers only; no text
 

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

That was the formula I needed. Thanks again.

"Biff" wrote:

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!D8:D1026))))

Biff

"roy.okinawa" wrote in message
...
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))))