Return cell value base on multiple columns and rows criteria

Chaozfate

Board Regular
Joined
Mar 15, 2017
Messages
52
ABCD
1Product A
2Gross Profit
3Balance1/6/202030/6/2020USD 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

Board Regular
Joined
Mar 15, 2017
Messages
52
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.
 

Some videos you may like

Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"

Watch MrExcel Video

Forum statistics

Threads
1,114,257
Messages
5,546,806
Members
410,759
Latest member
Bufnercash
Top