|Thanks for your response,|
I am using Excel 2010.
Imagine a table with column headings as below:
Name, Level, Plan 1, Plan 1 Tested, Plan 2, Plan 2 tested, Plan 3, Plan 3 tested
Level is a number, "tested" columns are a "yes" or "no"- everything else free text.
I can use a SUMPRODUCT to look along the tested columns to count all "yes" by Level, but I can't get the count to happen where Users do not have 3 plans. If a user has 1 or 2 plans, but the plans they do have are tested, I want to count that.