So here's the formula.
=(C8*'Data Tables'!B3+'Driver Input Form'!D8*'Data Tables'!C3+'Driver Input
Form'!E8*'Data Tables'!D3+'Driver Input Form'!F8*'Data Tables'!E3+'Driver
Input Form'!G8*'Data Tables'!F3+'Driver Input Form'!H8*'Data
Tables'!G3+'Driver Input Form'!I8*'Data Tables'!H3)
I am assuming the C8 is also in sheet 'Driver Input Form'.
As others have suggested, after row 8, temporarily insert a row (now
row 9), and in C9 enter =len(C8), then copy that across through I9.
If you expect zero in any of C9:I9 because the corresponding cell in
C8:I8 appears to be empty, this might reveal that it is not truly
empty. Note that "" and " " are not the same as an empty cell
(WYSInotWYG <sigh>), and __sometimes__ they are not treated the same
as empty cell (consistency is not Excel's strong suit <sigh>).
Delete row 9. If that does not reveal the source of the #VALUE error
(i.e. the non-empty cell), do something similar in the 'Data Tables'
sheet. That is, after row 3, temporarily insert a row (now row 4) and
enter =len(B3) in B4 and copy across through H4. Again, look for non-
zero where you would expected zero. And again, delete row 4 when you
are done.
Thanks all...it's a lengthy formula and there may have been an easier way to
do it but I'm somewhat a novice.
Again, assuming that C8 is in the 'Driver Input Form', you could
replace the long formula with simply:
=sumproduct(C8:I8, 'Data Tables'!B3:H3)
Ironically, that might also mask the problem creating the #VALUE
error. But it would be prudent to locate the source of the #VALUE
error, if not fix it, just to be sure that the contents are what you
intended.
BTW, I wrote C8:I8 instead of 'Driver Input Form'!C8:I8 because I ass-
u-me that this formula is on in the 'Driver Input Form' sheet, if
"C8+..." works for you. On the other hand, if the formula is not in
the 'Driver Input Form' sheet, perhaps the unqualified C8 in the
formula is the source of the #VALUE error insofar as that is the wrong
cell reference, and you intended it to be 'Driver Input Form'!C8.
Final comment: If you stick with the long formula, which I represent
as "a+b+c+...", beware that in Excel, the result of "(a+b+c+...)" is
not always the same as "a+b+c+...". In the latter case, Excel might
make an adjust toward zero if the result is infinitesimally different
from zero. This is an attempt to correct for small numerical errors
that creep into computation as an avoidable consequence of using a
binary representation of decimal fractions. Only you can decide which
result you would prefer. But generally, it is prudent to remove
superfluous parentheses, if only to improve readability (in more
complex formulas).
HTH.
