How to sumproduct cell arrays?
Typing =SUMPRODUCT({0.5,1,0.5},{4,3,2}) into a cell gives a result of 6. I’m trying to get the same result by putting {0.5,1,0.5} in cell A1, {4,3,2} in cell A2, and =SUMPRODUCT(A1,A2) in cell A3, but when I try this I get the #VALUE error in A3. Is there a way to carry out this SUMPRODUCT with the arrays being drawn from their own separate cells?
What exactly are you trying to do here? Where are those values coming from?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
One array is quantity of product and the other array is the price at which it was sold. SUMPRODUCT would give me a running total. I want the arrays in their own separate cells so I can visually separate quantity and price, and edit a number here and there when necessary.
So you have a bunch of prices all in the same cell?
If so, it would be better to break them out
Cross-posted here
Audere est facere
After looking around a bit, it does seem the best thing to do is put each number in it's own cell after all.
Yes, it almost always is, that way excel can treat each number on its own
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks