Countif and indirect formula

  • 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.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!