Hi,
I'm looking for help with a formula.

In a file, report.xls A1, I am trying...
IF([data.xls]car'!A1="7:00",IF([data.xls]car'!B1="Car",'(car.xls!A3:A5)))

The dilemma is the data.xls file will skip some half hour intervals; while
the report.xls adds all intervals, even when there are no numbers to report.
dilemma #2...
Retort.xls has two tabs- truck and car.
Any help or suggestions are greatly appreciated.
Thanks,
Jeff

data.xls (this daily report is 2X100's pages)
7:00 car 65 98 78
7:30 truck 5 16 35
8:00 car 45 87 99
8:30 car 44 89 122
10:00 truck 15 79 342
10:30 truck 16 72 45
10:30 car 85 24 57

report.xls (car tab after formula)
7:00 car 65 98 78
7:30
8:00 car 45 87 99
8:30 car 44 89 122
9:00
9:30
10:00
10:30 car 85 24 57

retort.xls (truck tab after formula)
7:00
7:30 truck 5 16 35
8:00
8:30
9:00
9:30
10:00 truck 15 79 342
10:30 truck 16 72 45