Quote:
Originally Posted by EcommDOC
Arvi I don't need sums of anything, I need to create 2 separate Pick list for 1 store from 1 huge pick list of multiple stores and 2 price points
|
When you calculate a sum which returns a numeric value from certain row, it works effectively as lookup. The idea is to compose conditions for sumifs() in a way, that a single numeric value is returned. I myself use this technique often, as it allows to apply unlimited number of conditions.