Multiplying and summing attributes that appear in a list
maybe someone can help me out with my problem.
I have a list, 50-150 rows long. The list is being filled regulary, and sometimes the word "Box" will pop up, followed by its width, hight and length, like this:
What I want to achieve is to sum the volumes of ALL boxes that pop up in the list.
Im thinking i could do this by locating the first "box" by searching from the top, multiplying the attributes with the shift or dislocate function or whatever its called in english, and search for the next "box" from there. However this would meen a very big formula...Could this be a task for Mr. Sumproduct perhaps...?
It will pop up 6-7 times.
Indeed, SUMPRODUCT will work.
The arrays in SUMPRODUCT, and other array type formulas, must have the same number of elements, but they do not have to all start on the same row.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1