The easiest way to do this is by:
1. Creating named ranges.
2. Using CHOOSE & INDIRECT function to dynamically return the multiple columns
3. Creating an array of TRUE/FALSE based on criteria
4. Summing the products of above arrays
=SUM(CHOOSE({1,2,3},INDIRECT(J4),INDIRECT(J5),INDIRECT(J6))*(Suppliers=J2))
Негізгі бет How to Sum multiple non-contiguous columns using a Criteria
No video
Пікірлер: 2