Manipulating ranges in a different file
Lenchik wrote:
=SUMPRODUCT(--(('path[FileA.xls]Tab1'!G3:G250 [...???...]
TIME(0,15,59))*(LEN('path[FileA.xls]Tab1'!Q3:Q250)=0)))
I use array formulas rather than SUMPRODUCT and would think this would
work (entered with Ctrl+Shift+Enter):
=SUM((('path[FileA.xls]Tab1'!G3:G250-'path[FileA.xls]Tab1'!F3:F250)
=TIME(0,16,0))*(LEN('path[FileA.xls]Tab1'!Q3:Q250)=0))
Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup
|