Hey (hey = hello in Georgia <g) Bob-

Weird. I still get an error value, even when I manually
re-create the data in A1:A10.

Regards,
Jason


-----Original Message-----
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






.



.