Sheet 1- B2(name referencing) and E2(the worksheet I'm referencing).
Sheet referencing- column D is the criteria that B2 is looking to match with column A being where I want the number of instances of the number 1 to be counted. Any help would be appreciated. Thank you.