Countifs or Sumifs

Originally Posted by XOR LX

It appears that you are under the impression that you can enter as many criteria - where those criteria are intended as "OR" criteria - for as many different ranges as you wish using COUNTIFS, which is not necessarily so.

+1
I'm only aware of being able to do 2 sets of {or} criteria in a sum/countIFs formula.
AND, those 2 criteria arrays need to be transposed of each other, 1 a column, the other a row..

=SUM(COUNTIFS(range1,{a,b,c,d},range2,{1;2;3}))
Notice one {array} is using comma seperators, the other is using semicolons.

You can't do 3.

I'd suggest
=SUM(COUNTIFS(range1,{a,b,c}))+SUM(COUNTIFS(range2,{1,2,3}))+SUM(COUNTIFS(range3,{8,9,10}))