"sanders" <
[email protected]> ha scritto
nel messaggio news:
[email protected]...
>
> Hi,
> I have a formula :
> =SUMPRODUCT((('Totals'!$A$5:$A$11=J5:J11)*('Totals'!$B$5:$M$11)))
> but it only returns the values for J5 J8 and J9, not 6, 7, 10 or 11, as
> you would expect it to do. I have checked and the values it is looking
> up are accurate (they work individually). Is this a problem with
> sumproduct or am I just being a bit dim?
>
> Thanks
>
Hi Sanders,
The SUMPRODUCT function needs arrays of the same numbers of elements, but
you ar multiplying an array of 7 (7 rows * 1 column) elements
('Totals'!$A$5:$A$11=J5:J11) by an array of 84 (7 rows * 12 column) elements
('Totals'!$B$5:$M$11), so it's right that the result is not what you
think... You have to fix the two arrray to have the same number of
elements... Check the on line help.
--
Hope I helped you.
Thanks in advance for your feedback.
Ciao
Franz Verga from Italy
Bookmarks