Hello!
Why do I get different answers between?
=SUMPRODUCT(B1:B4,C1:F1)
(#VALUE!)
and
=SUMPRODUCT(B1:B4,C1:C4)
(44)
My data is:
B C D E F
1 11 1 0 1 0
2 22 0
3 33 1
4 44 0
Thank you!
Hello!
Why do I get different answers between?
=SUMPRODUCT(B1:B4,C1:F1)
(#VALUE!)
and
=SUMPRODUCT(B1:B4,C1:C4)
(44)
My data is:
B C D E F
1 11 1 0 1 0
2 22 0
3 33 1
4 44 0
Thank you!
Last edited by VBA Noob; 12-17-2007 at 04:39 PM.
You can't use a column and a row like that, try this "array formula" has to be confirmed with CTRL+SHIFT+ENTER
=SUM((B1:B4)*TRANSPOSE(C1:F1))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks