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