why do i get #value! using this formula

N

Naraine Ramkirath

can someone let me know why this formula is not working?

=SUMPRODUCT(--('Budget Dec 07'!A3:A19=Report!B9),--('Budget Dec
07'!I1:T1=6),'Budget Dec 07'!I3:T19)
 
B

bj

the arrays are not the same size
(17,12,17)
in sumproduct each array must have the same number off items
 
H

Harlan Grove

Naraine Ramkirath said:
can someone let me know why this formula is not working?

=SUMPRODUCT(--('Budget Dec 07'!A3:A19=Report!B9),
--('Budget Dec 07'!I1:T1=6),'Budget Dec 07'!I3:T19)
Click to expand...

You have 17-by-1, 1-by-12 and 17-by-12 ranges, so you need to make the
first two into a single array expression. Rearranging the terms, try

=SUMPRODUCT('Budget Dec 07'!I3:T19,
('Budget Dec 07'!A3:A19=Report!B9)*('Budget Dec 07'!I1:T1=6))
 
N

Naraine Ramkirath

Harlan,
this formula evaluates to zero. could there be a bracket missing?
 
Top