Hi and thanks in advance,
I have two arrays in a spreadsheet. I'll give an eg below ...
How do I find the sum of all values in array two that correspond to a particular value in array one?Please Login or Register to view this content.
For eg...
- the number "2" in array one is in cells Aiii and Bii,
- cells Aiii and Bii from array one correspond to cells Aix and Bviii in array two
- therefore, the sum of cells corresponding to the number two is 10 ( from 4 + 6 = 10)
The result i want will show the following ...
Cheers.Please Login or Register to view this content.
Josh
Bookmarks