dwarnimont
Board Regular
- Joined
- Jan 12, 2010
- Messages
- 71
What is formula, sumifs, indirect, other, to sum based on multiple input criteria (similar to vloookup + hvoolup) where it sums data in one column, based on input to select this column from with range of data.
Example objective. Sum all that meet input criterias. Input=SKU, range is Col A. Input=year, range is row #1 . for example if it is SKU B and year 2019, goto sum range and return the sum.
This is very close to sumifs, yet it is not fixed on a specific column and must select the column to sum based on input criteria.
<colgroup><col><col><col span="4"></colgroup><tbody>
</tbody>
Example objective. Sum all that meet input criterias. Input=SKU, range is Col A. Input=year, range is row #1 . for example if it is SKU B and year 2019, goto sum range and return the sum.
This is very close to sumifs, yet it is not fixed on a specific column and must select the column to sum based on input criteria.
A | B | C | D | E | |
1 | SKU | 2018 | 2019 | 2020 | 2021 |
2 | A | 11,751 | 35,382 | 73,246 | 126,215 |
3 | B | 10,009 | 29,687 | 59,580 | 101,894 |
4 | C | 9,890 | 29,509 | 59,580 | 101,894 |
5 | A | 9,648 | 29,241 | 59,580 | 101,894 |
6 | A | 41,298 | 123,819 | 251,986 | 431,897 |
7 | C | 4,573 | 8,340 | 22,382 | 60,470 |
8 | C | 4,086 | 7,043 | 16,627 | 44,534 |
9 | B | 4,114 | 7,097 | 16,627 | 44,534 |
10 | A | 4,081 | 7,057 | 16,627 | 44,534 |
11 | A | 16,854 | 29,537 | 72,263 | 194,072 |
12 | |||||
13 | Input (formula) | ||||
14 | SKU | B | |||
15 | Year | 2019 | |||
16 | |||||
17 | Formula answer--> | 36,784 |
<colgroup><col><col><col span="4"></colgroup><tbody>
</tbody>