Thread: CSE function with #VALUE errors
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Phillip[_2_] Phillip[_2_] is offline
external usenet poster
  
Posts: 2
Default CSE function with #VALUE errors
On Thu, 04 Oct 2007 18:12:46 -0400, T. Valko wrote:

Try this array formula (CSE):

All on one line.

=SUM(IF(ISNUMBER(SEARCH("buy",A1:A10)),
--LEFT(A1:A10,FIND(" ",A1:A10)-1)))



Thanks. That'll make life a lot easier

P
Reply With QuoteReply With Quote