In my effort to understand this elusive function, I am reading this very carefully. But this part stumps me:
Aren't they the same? They're both 6 cells?=SUMPRODUCT((A1:A6="X")*(B20:B25>4))
because the second range is smaller than the first.
In my effort to understand this elusive function, I am reading this very carefully. But this part stumps me:
Aren't they the same? They're both 6 cells?=SUMPRODUCT((A1:A6="X")*(B20:B25>4))
because the second range is smaller than the first.
Office 2010, Windows 7
goal: to learn the most efficient way