You could add another IF statement that says if the result = 0, then return
"" otherwise just execute the formula you just laid out.
--
Tips for Excel, Word, PowerPoint and Other Applications
http://www.kan.org/tips


"Frank Situmorang" wrote:

Hello:

Following is my formula to be put in data sheet ( destination sheet) while
New Invoice List is the name of my source sheet.

My problem is the blank date in the source sheet is shown as " 0-Jan-00",
while I want it to renturn just as source/ blank.

Please help me how can we make it , because in the summary sheet I want to
make the sum if blank or zero 0, will not be calculated.

=IF(ISNA(VLOOKUP(H6674,'[NEW INVOICE LIST.xlsb]INVOICE
''08'!$A$7:$AX$6000,32,FALSE)),IF(ISNA(VLOOKUP(H66 74,'[NEW INVOICE
LIST.xlsb]INVOICE ''07'!$A$7:$AX$6000,31,FALSE)),IF(ISNA(VLOOKUP(H66 74,'[NEW
INVOICE LIST.xlsb]INVOICE
''06'!$A$7:$AX$6000,31,FALSE)),IF(ISNA(VLOOKUP(H66 74,'[NEW INVOICE
LIST.xlsb]INVOICE ''05'!$A$7:$AX$6000,29,FALSE)),VLOOKUP(H6674,'[NEW INVOICE
LIST.xlsb]INVOICE ''05'!$A$7:$AX$6000,29,FALSE)),VLOOKUP(H6674,'[NEW INVOICE
LIST.xlsb]INVOICE ''06'!$A$7:$AX$6000,31,FALSE)),VLOOKUP(H6674,'[NEW INVOICE
LIST.xlsb]INVOICE ''07'!$A$7:$AX$6000,31,FALSE)),VLOOKUP(H6674,'[NEW INVOICE
LIST.xlsb]INVOICE ''08'!$A$7:$AX$6000,32,FALSE))

--
H. Frank Situmorang