Do you mean that you want 10 results in, say, C1:C10, or that you want
one result of them all added together?

When you say "skip cells if either of them are text", do you mean you
want to ignore both A and B cells on that row if one contains text, or
that you don't want to include the text value in the addition because
it will cause an error?

Are you trying to do this in a macro?

Pete

On Oct 30, 7:15*pm, jlclyde wrote:
I have a 2 ranges of cells that are equal size and I would ilke to add
them together. *Here is where I am drawing a blank. *say
range("A1:A10" is the first range and Range("B1:B10") is the 2nd
range. *I woudl like to add A1 to B1 and A2 to B2 and so on. *I want
to skip cells if either one of them are text. *I was thinking For
each.... but do nto know what this would look like. *Any help would be
greatly appreciated.

Thanks,
Jay