In my effort to understand this elusive function, I am reading this very carefully. But this part stumps me:
=SUMPRODUCT((A1:A6="X")*(B20:B25>4))

because the second range is smaller than the first.
Aren't they the same? They're both 6 cells?