cmccurdy
asked on
Formula to count all occurances in a database which meet criteria
I need a formula to count all occurrences of each number from to 10 found in the data for each control. (I've simplified this, in production the numbers range from 1 to 70)
For example, how many times was 1 found in one of Groups where the Control was 11.
I think I need some combination of dcount but I couldn't figure out how to have it return results from multiple columns.
Attached is a sample data table and the desired output table.
Sample.xlsx
For example, how many times was 1 found in one of Groups where the Control was 11.
I think I need some combination of dcount but I couldn't figure out how to have it return results from multiple columns.
Attached is a sample data table and the desired output table.
Sample.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER