Return cell value base on multiple columns and rows criteria

[Chaozfate]

	A	B	C	D
1				Product A
2				Gross Profit
3	Balance	1/6/2020	30/6/2020	USD 1,000

Dear All,

**I tried search thru the whole forum but very unlikely any formula provided before match my request. Hence i decided to post a new thread.

Objective: The above shows a partial extraction from my big work book, I wish to retrieve the value of USD1,000 in another sheet tab based on the criteria in column A3, B3, C3, and row D1, D2.

Would be very much appreciated if anyone could advise and assist to draft if there is a formula exist for retrieving the value on D3 based on multiple criteria at respective columns and rows.

Thanks and regards,
Fate

 

[Chaozfate]

yes, i saw, but my database is not sorted vertically like how your sample does. so SUMIFS doesn't work for me.

To be precise, if we refer at your sample sheet, I wish to generate the data which u presented at sheet 2 from the database in your sheet 6. (not generating data at your sheet 6 from your sheet 2)

Which mean, I have to retrieve a figure based on the criteria at horizontal as well as criteria from vertical, so only SUMPRODUCT for now, i guess.