Forum Discussion
COUNTIF with Criteria
Hi I am trying to count how many rows in the "C" column with different criteria that are listed in "P" column and set as "Wave-4". The criteria in "C" are Sybase","MariaDB","MongoDB","Oracle","...
Try the formula below - put the list of conditions in curly braces to make an array, and then wrap the whole thing in a SUM unless you want the count for each condition to be spilled into adjacent cells in the same row.
=SUM(COUNTIFS(PlanningList!$C$2:$C$1792,{"Sybase","MariaDB","MongoDB","Oracle","SQL"},PlanningList!$P$2:$P$1792,"Wave-4"))
