Excel Formula - Sum values based on conditions

[hrayani]

Hello Friends,

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

 

[Fluff]

How about

=SUMPRODUCT(SUMIFS(C2:C9,B2:B9,B12,A2:A9,IF(COUNTA(A12:A15)=0,"*",A12:A15)))

 

[hrayani]

How about

=SUMPRODUCT(SUMIFS(C2:C9,B2:B9,B12,A2:A9,IF(COUNTA(A12:A15)=0,"*",A12:A15)))

Thanks Fluff....
Working exactly the way I wanted it to

 

[Fluff]

Glad to help & thanks for the feedback.