Formula help

[Donna Hernandez]

I am trying to create a few formula's for the following

# of New Boxes QAed:     >>>>	0	# of Those Boxes Failed QA:     >>>>	0
Failed Box #'s:	Part #:	PG #:	Reason For Failure:

What I want to do is get information from the bottom sheet to the top sheet. 

I want to say if a box has failed (which there will be an "X" in the box) I want the box #, part #, page # and reason to automatically copy to the sheet above.

I also want next to "# of new boxes qaed" to add up for how many done that day and in the "# of those boxes failed qa" to only add up the boxes that failed.

	Task	Box	Passed	Failed	Part #	PG #	Reason
1
2
3
4
5

[#2]

Can you give us an example of what this looks like with sample data please

[#3]

Alun, that's here https://techcommunity.microsoft.com/t5/user/viewprofilepage/user-id/79142

[#4]

Sergei,

Thanks for the clarification