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
There is SUM IF or SUM OR combination but SUMOR doesnt exist. For further information you can visit https://www.zetexcel.com/
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.