why do i get #value! using this formula

  • Thread starter Thread starter Naraine Ramkirath
  • Start date Start date
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)
 
the arrays are not the same size
(17,12,17)
in sumproduct each array must have the same number off items
 
thanks for the clarification.
bj said:
the arrays are not the same size
(17,12,17)
in sumproduct each array must have the same number off items
Click to expand...
 
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))
 
Harlan,
this formula evaluates to zero. could there be a bracket missing?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

help to count easily 2
Need Function for Year-to-Date spent total 3
MONTH() question 5
Sumproduct with multiple criteria using indirect formula 4
Setting up "Progressive" Formulas between worksheets/files 1
Finding the earliest date from a range of cells 2
Conditional SUM for Budget, Actuals, & Variance YTD columns 0
Calculation using result from Index/Match 10

Back
Top