COUNTIFS / SUMIFS with OR - COUNTOR, SUMOR
Countifs or Sumifs function use all criteria as AND. Instead 2 more formula can be added such that all criteria are treated as OR. Suggested Names of Formula are
Kevin Osborn commented
I like it but I'd prefer the implementation of the FILTER function (see link to idea below) as it would deal w/ all these various alterations to COUNT, SUM, etc.
Pravin Mali commented
Agree with Ravi for above suggestions. Also, there should be count unique option is future versions.