Excel Magic Trick 1513: COUNTIFS from Multiple Cells!?!? Array Formula or Logical Formula?

Download Excel File: https://ift.tt/2BNJeQM
Entire page with all Excel Files for All Videos: https://ift.tt/1kSFWvs

In this video see how to count values that are greater than a hurdle when the values in in noncontiguous cells (cells not next to each other). See an Array Formula that uses SUMPRODUCT and CHOOSE and a Logical Formula.

View on YouTube