Forum Discussion

MMHiggins's avatar
MMHiggins
Copper Contributor
Sep 01, 2021
Solved

Formula Assistance

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 colu...
  • Detlef_Lewin's avatar
    Sep 01, 2021

    MMHiggins 

    For "Eng":

    =COUNTIFS(B2:B20,"Eng",A2:A20,"<>")+COUNTIFS(B2:B20,"Eng",C2:C20,"<>")