See Mr Excel and excelisfun have an epic back and forth duel that shows many ways to add or count with OR Criteria:
(01:12) Excel Table feature with a Total Row with SUBTOTAL function for adding (109) and counting (103)
(02:25) Database functions: DSUM and DCOUNTA
(03:56) Slicer for Excel Table feature and SUBTOTAL Functions
(04:28) Slicer for PivotTable
(04:50) COUNTIFS and SUMIFS with wild card asterisk *
(05:47) Two COUNTIF functions. Two SUMIF functions.
(06:05) SUMPRODUCT and COUNTIF with a Function Argument Array Operation. SUMPRODUCT and SUMIF with a Function Argument Array Operation.
(07:15) SUM and LOOKUP. SUMPRODUCT and LOOKUP.
(09:06) SUMPRODUCT and COUNTIFS. SUMPRODUCT and SUMIFS.
(09:19) Use an Array Constant as the Function Argument Array Operation and avoid Ctrl + Shift + Enter.
(10:45) SUMPRODUCT, ISNUMBER and MATCH
(10:52) SUM and IF and Boolean OR calculation