Hi,
Does a combination of multiple 'sumproduct' become an array?
I noticed that when I combine 5 and more 'sumproduct's it wont work unless I make it an array.
Is my assumption correct? Are you familiar with something like that?
Thanks.
Hi,
Does a combination of multiple 'sumproduct' become an array?
I noticed that when I combine 5 and more 'sumproduct's it wont work unless I make it an array.
Is my assumption correct? Are you familiar with something like that?
Thanks.
It will depend entirely on HOW you are combining them. More detail, please ...
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
I'm referring to another thread in this forum (see below link) where I had to use 5 sumproduct in the formula. If I reduce in to 4 or less it works as a regular type.
But as given in the file - it won't work without turning it to array.....
https://www.excelforum.com/excel-for...ml#post5340064
Works fine here without CSE - must be an Office 2010 limitation.
Oh really. Thanks for checking this for me AliGW.
No problem.
While you maintain inventory, why not in simple way product wise opening stock, receiving, issuing quantity with sumifs function.
atul
If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.
Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".
AVK - you might wish to suggest this in the thread from which this came.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks