the cell in question has to contain a value or a formula (or be blank). If
it contains a formula, then it is unclear where you are testing.

Instead of saying Cell in question, say

if A1 contains text then in cell B6513 display "" else display
SUM(C6513:M6513),

=if(istext(A1),"",SUM(C6513:M6513))

as an example.

--
Regards,
Tom Ogilvy



" wrote:

Trying to create a formula that will sum 5 cells to the right of the
cell in question if the cell the cell in question contains a Numerical
value, and that will do nothing if the cell in question contains text.

I have gotten as far as:

IF(TYPE(1), SUM(C6513:M6513), "")

Obviously, "" does not return the same text originally in the cell, but
instead a 0.