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","...
=SUMPRODUCT(COUNTIFS(PlanningList!$C$2:$C$1792,{"Sybase","MariaDB","MongoDB","Oracle","SQL"},PlanningList!$P$2:$P$1792,"Wave-4"))
This formula works in my Excel 2013 sheet.