Microsoft Office Forums - View Single Post - [Solved] How to Subtract value in table, based on two different conditions

Thread: [Solved] How to Subtract value in table, based on two different conditions

View Single Post

Old

06-19-2015, 01:28 AM

Catalin.B

Catalin.B is offline

Catalin.B uses Windows Vista

Windows Vista Catalin.B uses Office 2010 32bit

Catalin.B uses Office 2010 32bit

Office 2010 32bit

Expert

Join Date: May 2011

Location: Iaşi, România

Posts: 386

Catalin.B is on a distinguished road

Default

Hi,
Try this formula in cell E16, copied down and to the right:
=INDEX($A$2:$E$5,MATCH($D16,$A$2:$A$5,0),MATCH(E$1 5,$A$2:$E$2,0))-IF(E$15>=$H$12,INDEX($J$2:$M$4,MATCH($D$12,$J$2:$J $4,0),MATCH($D16,$J$2:$M$2,0)),0)

Cheers,

Attached Files

Copy of Subtract value based on two different conditions.xlsx (9.5 KB, 10 views)

Reply With Quote