"Phillip" wrote in message
...
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

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP