spalmerIron ContributorDec 22, 2023SolvedFormula Help Hello everyone, I'm trying to build a staffing plan based on grade levels and I need a formula to help me with it. I attached an example of what I'm trying to do. So you could see I have names in col...Show MoreStaffing plan.xlsx13 KBmtarlerDec 22, 2023spalmer try this:=COUNTIFS(D$3:D$17,"",$C$3:$C$17,$B20)+COUNTIFS(D$18:D$19,$B20)see attachedStaffing plan.xlsx13 KB
mtarlerDec 22, 2023spalmer try this:=COUNTIFS(D$3:D$17,"",$C$3:$C$17,$B20)+COUNTIFS(D$18:D$19,$B20)see attachedStaffing plan.xlsx13 KB
mtarlerDec 22, 2023spalmer try this:=COUNTIFS(D$3:D$17,"",$C$3:$C$17,$B20)+COUNTIFS(D$18:D$19,$B20)see attachedStaffing plan.xlsx13 KB
mtarlerSilver ContributorDec 22, 2023spalmer try this:=COUNTIFS(D$3:D$17,"",$C$3:$C$17,$B20)+COUNTIFS(D$18:D$19,$B20)see attachedStaffing plan.xlsx13 KB
spalmerIron Contributor to mtarlerDec 23, 2023That worked! thank you very much mtarler. I really appreciate your time and help in this
