What error does is suggest?

  • Thread starter Thread starter crapit
  • Start date Start date
C

crapit

What is the Error?

=SUMPRODUCT(-(INDIRECT(A$7)=$S10),-(INDIRECT(A$7 & ".dates")=$I8)) return
#ref


A$7 refer to to a value on that cell, which is also the name of the
spreadsheet. i.e A$7 = Orginal

$S10 is a six digits number.

(A$7 & ".dates") = Original.dates which is a Named that refer to a column
also in spreadsheet "Original"

$i8 is a date value.
 
You're not specifying any cells in that first expression. Maybe something like:

=SUMPRODUCT(--(INDIRECT(A$7&"!A1:A10")=$S10),--(INDIRECT(A$7 & ".dates")=$I8))

(I used A1:A10, but you'll want to match the same number of rows as
original.dates has.)

As long as that name in A7 doesn't need to be surrounded by apostrophes!
 
i got it thanks
Dave Peterson said:
You're not specifying any cells in that first expression. Maybe something
like:

=SUMPRODUCT(--(INDIRECT(A$7&"!A1:A10")=$S10),--(INDIRECT(A$7 &
".dates")=$I8))

(I used A1:A10, but you'll want to match the same number of rows as
original.dates has.)

As long as that name in A7 doesn't need to be surrounded by apostrophes!
Click to expand...
 
Back
Top