why do i get #value! using this formula
 

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)

why do i get #value! using this formula
 

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

"Naraine Ramkirath" wrote:

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)

why do i get #value! using this formula
 

thanks for the clarification.
"bj" wrote in message
...
the arrays are not the same size
(17,12,17)
in sumproduct each array must have the same number off items

"Naraine Ramkirath" wrote:

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)

why do i get #value! using this formula
 

"Naraine Ramkirath" wrote...
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)

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))

why do i get #value! using this formula
 

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


"Harlan Grove" wrote in message
oups.com...
"Naraine Ramkirath" wrote...
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)

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))