View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
roy.okinawa
 
Posts: n/a
Default 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))))