Hello:
Please refer to the attached sheet with sample data.
Sheet1 has some data which is used in Sheet2 to Summarize the quantity of each item used.
I am using formula
{=IFERROR(INDEX(Sheet1!$G$1:$G$20000,MATCH(1,IF(Sheet1!$E$1:$E$20000=D$2,IF(Sheet1!$D$1:$D$20000=$A4,IF(Sheet1!$A$1:$A$20000=$A$1,1))),0)),"")}
The result i wanted to see was -2+7=+5 in cell D5 of sheet2.
I am not sure if this formula is wrong.
Please help correct the formula which is in cell D4:D
Please let me know if any questions.
Thank you
Riz Momin
Bookmarks