Hello Friends,
Please have a look at the below sample data and kindly provide a solution for this
Please have a look at the below sample data and kindly provide a solution for this
TEST FILE.xlsm | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | Supplier | SAMPLING | VALUE | |||
2 | Humayun | JAN - 2021 | 256 | |||
3 | Charlie | JAN - 2021 | 257 | |||
4 | Charlie | JAN - 2021 | 258 | |||
5 | John | APR - 2021 | 987 | |||
6 | Peter | APR - 2021 | 999 | |||
7 | Humayun | JAN - 2021 | 101 | |||
8 | Peter | JAN - 2021 | 658 | |||
9 | John | JUL - 2021 | 1,999 | |||
10 | ||||||
11 | Supplier | SAMPLING | VALUE | |||
12 | Humayun | JAN - 2021 | 872 | < Formula Required to sum value based on 2 criteria | ||
13 | Charlie | 1) look at column B for sampling | ||||
14 | 2) look at list in A12:A15 for suppliers | |||||
15 | If list in A12:A15 is empty then sum all clients | |||||
Sheet7 |