Hi Jason,

This is my data

art show 10
trade show 18
store 14
a 1
a 1
a 1
a 1
A 1
A 1
a 1


and I get 49. Is the NG wrap around losing a space character? If I remove
that space in my formula, I get #VALUE.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Jason Morin" wrote in message
...
Bob-

Even if both criteria are met, it still returns #VALUE!.

Jason

-----Original Message-----
It will if not all cells have valid data, see my two
points.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Bob Umlas" wrote in message
...
That gave me #Value!

"Bob Phillips"
wrote in message
...
=SUMPRODUCT(--(MID(A1:A10,FIND("~",SUBSTITUTE
(A1:A10,"
","~",LEN(A1:A10)-LEN(SUBSTITUTE(A1:A10," ",""))))
+1,99)))

where A1:A10 is the cells in question.

Two points,

each cell must have at least one space before the
number
all cells must have data

--

HTH

RP
(remove nothere from the email address if mailing
direct)


"nicklissa"
wrote in message
news:1F6E39CC-50F2-43AA-A8B1-
...
I would like to combine numbers and text in the
same cell, and sum the
numbers at the bottom of a column. Is there a way
I can do this? The
text
has no numerical value, and I wish the function to
ignore it entirely.

Example of what I need:

art show 10
trade show 18
store 14

42 (total of numbers in cells)

Any clues appreciated! -Nick






.