Looking for Counting formula

[zahidrock]

I have two sheet in one excel file, column A, B, C available on sheet 1 and F,G,H,I,J,K available on sheet two, i want to get count on sheet 2 G to K column, but on sheet1 A column have multiple name of one, so that i need to use it for Vlookup formula, but with Vlookup formula not give me counting on sheet2.

i also need one thing that when i put OUT on Sheet1 status column on that time i need to automatically remove that product on sheet2.

 

[zahidrock]

Sheet1, A:D, houses the data.

Sheet2, A:F, houses the set up for counting...

Sheet2, B2, copied across and down:

=COUNTIFS(Sheet1!$A:$A,$A2,Sheet1!$B:$B,B$1,Sheet1!$D:$D,"<>OUT")

Thanks, but bro, out option not working, please check it...

 

[Aladin Akyurek]

Thanks, but bro, out option not working, please check it...

See the workbook that implements the set up:
https://dl.dropboxusercontent.com/u/65698317/zahidrock%20%20countifs.xlsx

 

[zahidrock]

See the workbook that implements the set up:
https://dl.dropboxusercontent.com/u/65698317/zahidrock%20%20countifs.xlsx

Oh thanks bro, it working, i was made one little mistake i put wrong Column on the out option. Thanks a lot..

 

[Aladin Akyurek]

Oh thanks bro, it working, i was made one little mistake i put wrong Column on the out option. Thanks a lot..

You are welcome.