Note that you will only be able to do "OR" conditions twice within the COUNTIFS. The first array constant is horizontal while the second array constant is vertical.
=SUM(COUNTIFS(myrange1, {1,2,3} , myrange2, {1;2;3} ))
Note that you will only be able to do "OR" conditions twice within the COUNTIFS. The first array constant is horizontal while the second array constant is vertical.
=SUM(COUNTIFS(myrange1, {1,2,3} , myrange2, {1;2;3} ))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks