How can I get rid of the FALSE..?

[Mykro]

{=IF(LEN(M91),IF($D$6:$J$64="TEXT",SUM($D$5:$J$63),""))}

If I don't have any data in the cells I get a
FALSE.. It works fine when data is entered.. I'm missing something...What??

 

[Aladin Akyurek]

On 2002-12-21 07:10, Mykro wrote:
Aladin,
That formulas works fine... Thanks Yogi..

I'm sorry... I'm not convinced.

I was talking about something else..

Yes, you were asking about double quotes, that is, "". That means null-string, or, nothing in informal talk.

I need to span text across multiple worksheets.

This formulas works here.. This I am using and it works fine..
=SUM(first:Last!A19) for summing numbers across worksheets.

Of course, that's what SUM does: summing numbers.

In this case I have to copy Names from one worksheet to another EX: (Sheet1!M90 "John Doe") to (Sheet2!B20 "John Doe) How can I to it Using the Sheets First:Last! ??

In B20 in Sheet2 you need to enter...

=Sheet1!M90

If you copy this down, you'll get...

in B21: =Sheet1!M91

etc.