try this

=IF(COUNTBLANK(A10:M10)=13,"all blank","not all blank")

--

Gary Keramidas
Excel 2003


"thomas donino" wrote in message
...
How would i test to see if EVERY cell in that range was blank?

"Dana DeLouis" wrote:

= sum(a10:m10) will = 0 if here is only text or zeroes,

Hi. The sum could be zero from, say, only two values of +5, and -5.
The op will have to decide want he wants to do.

:)
Dana DeLouis




Gary Keramidas wrote:
i was going to throw one out there too, but i can't really see the logic
here. if there are no numbers, you're not going to have a sum anyway.

so, = sum(a10:m10) will = 0 if here is only text or zeroes, and a value
if a number is contained in the range.

or, am i missing something?