You probably have a cell in the range that contains the #NAME? error.

You said you have a formula that returns 1 if TRUE. What does it return if
FALSE?

See if one of these does what you want...

=SUMIF(I5:I56314,"<1E100")

=COUNTIF(I5:I56314,1)

--
Biff
Microsoft Excel MVP


"Groybs" wrote in message
...
I have a spreadsheet with 56,314 rows of text labels.

I have a formula in each row off to the right of each text label. The
formula tests for a specific text string contained in the label and
records a
1 if true.

At the top of the sheet above this column of formulas, I want to sum the
number of 'TRUE' responses, or 1(s).

My formula is: =SUM(I5:I56,314). But this returns a #NAME? error
message. If I limit the SUM formula to not cover beyond cell I9168, then I
get a correct answer and no error msg.

Is this a limit of Excel's ability to calculate, a limitation imposed by
my
RAM resources, or something else ?