SOLVED

Formula Assistance

%3CLINGO-SUB%20id%3D%22lingo-sub-2709577%22%20slang%3D%22en-US%22%3EFormula%20Assistance%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2709577%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%20Microsoft%20Community!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20in%20need%20of%20formula%20help%20once%20again.%20I%20want%20to%20COUNT%20the%20number%20of%20entries%20in%20two%20separate%20columns%20(A%20and%20C)%20but%20only%20if%20they%20meet%20certain%20criteria%20in%20a%20third%20column%20(B).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EQ%3A%20What%20is%20the%20total%20number%20of%20services%20provided%20to%20those%20who%20speak%20English%20AND%20what%20is%20the%20total%20number%20of%20services%20provided%20to%20those%20who%20speak%20Spanish%3F%20The%20sum%20total%20of%20services%20equals%2020.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EExample%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CTABLE%20width%3D%22564%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%22103.219px%22%20height%3D%2230px%22%3E%3CSTRONG%3EA%3C%2FSTRONG%3E%3C%2FTD%3E%3CTD%20width%3D%2281.9844px%22%20height%3D%2230px%22%3E%3CSTRONG%3EB%3C%2FSTRONG%3E%3C%2FTD%3E%3CTD%20width%3D%2289.75px%22%20height%3D%2230px%22%3E%3CSTRONG%3EC%3C%2FSTRONG%3E%3C%2FTD%3E%3CTD%20width%3D%2276.4062px%22%20height%3D%2230px%22%3E%3CSTRONG%3ED%3C%2FSTRONG%3E%3C%2FTD%3E%3CTD%20width%3D%22130.312px%22%20height%3D%2230px%22%3E%3CSTRONG%3EE%3C%2FSTRONG%3E%3C%2FTD%3E%3CTD%20width%3D%2281.3281px%22%20height%3D%2230px%22%3E%3CSTRONG%3EF%3C%2FSTRONG%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22103.219px%22%20height%3D%2230px%22%3EServices%20A%3C%2FTD%3E%3CTD%20width%3D%2281.9844px%22%20height%3D%2230px%22%3ELanguage%3C%2FTD%3E%3CTD%20width%3D%2289.75px%22%20height%3D%2230px%22%3EServices%20B%3C%2FTD%3E%3CTD%20width%3D%2276.4062px%22%20height%3D%2230px%22%3EColumn3%3C%2FTD%3E%3CTD%20width%3D%22130.312px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2281.3281px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22103.219px%22%20height%3D%2230px%22%3ECS%3C%2FTD%3E%3CTD%20width%3D%2281.9844px%22%20height%3D%2230px%22%3EEng%3C%2FTD%3E%3CTD%20width%3D%2289.75px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2276.4062px%22%20height%3D%2230px%22%3E-%3C%2FTD%3E%3CTD%20width%3D%22130.312px%22%20height%3D%2230px%22%3E-%3C%2FTD%3E%3CTD%20width%3D%2281.3281px%22%20height%3D%2230px%22%3E-%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22103.219px%22%20height%3D%2230px%22%3ECS%3C%2FTD%3E%3CTD%20width%3D%2281.9844px%22%20height%3D%2230px%22%3EEng%3C%2FTD%3E%3CTD%20width%3D%2289.75px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2276.4062px%22%20height%3D%2230px%22%3E-%3C%2FTD%3E%3CTD%20width%3D%22130.312px%22%20height%3D%2230px%22%3E-%3C%2FTD%3E%3CTD%20width%3D%2281.3281px%22%20height%3D%2230px%22%3E-%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22103.219px%22%20height%3D%2230px%22%3EMA%3C%2FTD%3E%3CTD%20width%3D%2281.9844px%22%20height%3D%2230px%22%3EEng%3C%2FTD%3E%3CTD%20width%3D%2289.75px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2276.4062px%22%20height%3D%2230px%22%3E-%3C%2FTD%3E%3CTD%20width%3D%22130.312px%22%20height%3D%2230px%22%3E-%3C%2FTD%3E%3CTD%20width%3D%2281.3281px%22%20height%3D%2230px%22%3E-%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22103.219px%22%20height%3D%2230px%22%3EMA%3C%2FTD%3E%3CTD%20width%3D%2281.9844px%22%20height%3D%2230px%22%3EEng%3C%2FTD%3E%3CTD%20width%3D%2289.75px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2276.4062px%22%20height%3D%2230px%22%3E-%3C%2FTD%3E%3CTD%20width%3D%22130.312px%22%20height%3D%2230px%22%3E-%3C%2FTD%3E%3CTD%20width%3D%2281.3281px%22%20height%3D%2230px%22%3E-%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22103.219px%22%20height%3D%2230px%22%3EMA%3C%2FTD%3E%3CTD%20width%3D%2281.9844px%22%20height%3D%2230px%22%3EEng%3C%2FTD%3E%3CTD%20width%3D%2289.75px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2276.4062px%22%20height%3D%2230px%22%3E-%3C%2FTD%3E%3CTD%20width%3D%22130.312px%22%20height%3D%2230px%22%3E-%3C%2FTD%3E%3CTD%20width%3D%2281.3281px%22%20height%3D%2230px%22%3E-%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22103.219px%22%20height%3D%2230px%22%3EMA%3C%2FTD%3E%3CTD%20width%3D%2281.9844px%22%20height%3D%2230px%22%3EEng%3C%2FTD%3E%3CTD%20width%3D%2289.75px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2276.4062px%22%20height%3D%2230px%22%3E-%3C%2FTD%3E%3CTD%20width%3D%22130.312px%22%20height%3D%2230px%22%3E-%3C%2FTD%3E%3CTD%20width%3D%2281.3281px%22%20height%3D%2230px%22%3E-%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22103.219px%22%20height%3D%2230px%22%3EPN%3C%2FTD%3E%3CTD%20width%3D%2281.9844px%22%20height%3D%2230px%22%3EEng%3C%2FTD%3E%3CTD%20width%3D%2289.75px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2276.4062px%22%20height%3D%2230px%22%3E-%3C%2FTD%3E%3CTD%20width%3D%22130.312px%22%20height%3D%2230px%22%3E-%3C%2FTD%3E%3CTD%20width%3D%2281.3281px%22%20height%3D%2230px%22%3E-%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22103.219px%22%20height%3D%2230px%22%3EPN%3C%2FTD%3E%3CTD%20width%3D%2281.9844px%22%20height%3D%2230px%22%3EEng%3C%2FTD%3E%3CTD%20width%3D%2289.75px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2276.4062px%22%20height%3D%2230px%22%3E-%3C%2FTD%3E%3CTD%20width%3D%22130.312px%22%20height%3D%2230px%22%3E-%3C%2FTD%3E%3CTD%20width%3D%2281.3281px%22%20height%3D%2230px%22%3E-%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22103.219px%22%20height%3D%2230px%22%3EPN%3C%2FTD%3E%3CTD%20width%3D%2281.9844px%22%20height%3D%2230px%22%3EEng%3C%2FTD%3E%3CTD%20width%3D%2289.75px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2276.4062px%22%20height%3D%2230px%22%3E-%3C%2FTD%3E%3CTD%20width%3D%22130.312px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2281.3281px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22103.219px%22%20height%3D%2230px%22%3EPT%3C%2FTD%3E%3CTD%20width%3D%2281.9844px%22%20height%3D%2230px%22%3EEng%3C%2FTD%3E%3CTD%20width%3D%2289.75px%22%20height%3D%2230px%22%3EA%3C%2FTD%3E%3CTD%20width%3D%2276.4062px%22%20height%3D%2230px%22%3E-%3C%2FTD%3E%3CTD%20width%3D%22130.312px%22%20height%3D%2230px%22%3EPO%3C%2FTD%3E%3CTD%20width%3D%2281.3281px%22%20height%3D%2230px%22%3EC%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22103.219px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2281.9844px%22%20height%3D%2230px%22%3EEng%3C%2FTD%3E%3CTD%20width%3D%2289.75px%22%20height%3D%2230px%22%3EB%3C%2FTD%3E%3CTD%20width%3D%2276.4062px%22%20height%3D%2230px%22%3E-%3C%2FTD%3E%3CTD%20width%3D%22130.312px%22%20height%3D%2230px%22%3EAC%3C%2FTD%3E%3CTD%20width%3D%2281.3281px%22%20height%3D%2230px%22%3E-%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22103.219px%22%20height%3D%2230px%22%3EMA%3C%2FTD%3E%3CTD%20width%3D%2281.9844px%22%20height%3D%2230px%22%3ESp%3C%2FTD%3E%3CTD%20width%3D%2289.75px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2276.4062px%22%20height%3D%2230px%22%3E-%3C%2FTD%3E%3CTD%20width%3D%22130.312px%22%20height%3D%2230px%22%3E-%3C%2FTD%3E%3CTD%20width%3D%2281.3281px%22%20height%3D%2230px%22%3E-%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22103.219px%22%20height%3D%2230px%22%3EMA%3C%2FTD%3E%3CTD%20width%3D%2281.9844px%22%20height%3D%2230px%22%3ESp%3C%2FTD%3E%3CTD%20width%3D%2289.75px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2276.4062px%22%20height%3D%2230px%22%3E-%3C%2FTD%3E%3CTD%20width%3D%22130.312px%22%20height%3D%2230px%22%3E-%3C%2FTD%3E%3CTD%20width%3D%2281.3281px%22%20height%3D%2230px%22%3E-%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22103.219px%22%20height%3D%2230px%22%3EMA%3C%2FTD%3E%3CTD%20width%3D%2281.9844px%22%20height%3D%2230px%22%3ESp%3C%2FTD%3E%3CTD%20width%3D%2289.75px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2276.4062px%22%20height%3D%2230px%22%3E-%3C%2FTD%3E%3CTD%20width%3D%22130.312px%22%20height%3D%2230px%22%3E-%3C%2FTD%3E%3CTD%20width%3D%2281.3281px%22%20height%3D%2230px%22%3E-%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22103.219px%22%20height%3D%2230px%22%3EMA%3C%2FTD%3E%3CTD%20width%3D%2281.9844px%22%20height%3D%2230px%22%3ESp%3C%2FTD%3E%3CTD%20width%3D%2289.75px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2276.4062px%22%20height%3D%2230px%22%3E-%3C%2FTD%3E%3CTD%20width%3D%22130.312px%22%20height%3D%2230px%22%3E-%3C%2FTD%3E%3CTD%20width%3D%2281.3281px%22%20height%3D%2230px%22%3E-%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22103.219px%22%20height%3D%2230px%22%3EPC%3C%2FTD%3E%3CTD%20width%3D%2281.9844px%22%20height%3D%2230px%22%3ESp%3C%2FTD%3E%3CTD%20width%3D%2289.75px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2276.4062px%22%20height%3D%2230px%22%3E-%3C%2FTD%3E%3CTD%20width%3D%22130.312px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2281.3281px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22103.219px%22%20height%3D%2230px%22%3EPC%3C%2FTD%3E%3CTD%20width%3D%2281.9844px%22%20height%3D%2230px%22%3ESp%3C%2FTD%3E%3CTD%20width%3D%2289.75px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2276.4062px%22%20height%3D%2230px%22%3E-%3C%2FTD%3E%3CTD%20width%3D%22130.312px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2281.3281px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22103.219px%22%20height%3D%2230px%22%3EPC%3C%2FTD%3E%3CTD%20width%3D%2281.9844px%22%20height%3D%2230px%22%3ESp%3C%2FTD%3E%3CTD%20width%3D%2289.75px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2276.4062px%22%20height%3D%2230px%22%3E-%3C%2FTD%3E%3CTD%20width%3D%22130.312px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2281.3281px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22103.219px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2281.9844px%22%20height%3D%2230px%22%3ESp%3C%2FTD%3E%3CTD%20width%3D%2289.75px%22%20height%3D%2230px%22%3EC%3C%2FTD%3E%3CTD%20width%3D%2276.4062px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22130.312px%22%20height%3D%2230px%22%3E-%3C%2FTD%3E%3CTD%20width%3D%2281.3281px%22%20height%3D%2230px%22%3E%3CP%3E-%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22103.219px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2281.9844px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2289.75px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2276.4062px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22130.312px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2281.3281px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22103.219px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2281.9844px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2289.75px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2276.4062px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22130.312px%22%20height%3D%2230px%22%3E%3CSTRONG%3ETotal%20Services%3A%3C%2FSTRONG%3E%3C%2FTD%3E%3CTD%20width%3D%2281.3281px%22%20height%3D%2230px%22%3E%3CSTRONG%3E20%3C%2FSTRONG%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22103.219px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2281.9844px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2289.75px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2276.4062px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22130.312px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2281.3281px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22103.219px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2281.9844px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2289.75px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2276.4062px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22130.312px%22%20height%3D%2230px%22%3E%3CSTRONG%3ETotal%20Eng%3A%3C%2FSTRONG%3E%3C%2FTD%3E%3CTD%20width%3D%2281.3281px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22103.219px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2281.9844px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2289.75px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2276.4062px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22130.312px%22%20height%3D%2230px%22%3E%3CSTRONG%3ETotal%20Sp%3A%3C%2FSTRONG%3E%3C%2FTD%3E%3CTD%20width%3D%2281.3281px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20helping%20me%20with%20the%20project%20with%20skills%20beyond%20my%20abilities.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2709577%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2709742%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%20Assistance%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2709742%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1134040%22%20target%3D%22_blank%22%3E%40MMHiggins%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20%22Eng%22%3A%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-excel-formula%22%3E%3CCODE%3E%3DCOUNTIFS(B2%3AB20%2C%22Eng%22%2CA2%3AA20%2C%22%26lt%3B%26gt%3B%22)%2BCOUNTIFS(B2%3AB20%2C%22Eng%22%2CC2%3AC20%2C%22%26lt%3B%26gt%3B%22)%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Hello, Microsoft Community!

 

I am in need of formula help once again. I want to COUNT the number of entries in two separate columns (A and C) but only if they meet certain criteria in a third column (B).

 

Q: What is the total number of services provided to those who speak English AND what is the total number of services provided to those who speak Spanish? The sum total of services equals 20. 

 

Example:

 

ABCDEF
Services ALanguageServices BColumn3  
CSEng ---
CSEng ---
MAEng ---
MAEng ---
MAEng ---
MAEng ---
PNEng ---
PNEng ---
PNEng -  
PTEngA-POC
 EngB-AC-
MASp ---
MASp ---
MASp ---
MASp ---
PCSp -  
PCSp -  
PCSp -  
 SpC -

-

      
    Total Services:20
      
    Total Eng: 
    Total Sp: 

 

Thank you for helping me with the project with skills beyond my abilities.

2 Replies
best response confirmed by MMHiggins (Occasional Contributor)
Solution

@MMHiggins 

For "Eng":

=COUNTIFS(B2:B20,"Eng",A2:A20,"<>")+COUNTIFS(B2:B20,"Eng",C2:C20,"<>")
Thank you, Detlef Lewin!