Excel Magic Trick 1513: COUNTIFS from Multiple Cells!?!? Array Formula or Logical Formula?
excelisfun
•
August 25, 2018
About
No channel description available.
Video Description
Download Excel File: https://excelisfun.net/files/EMT1513.xlsx Entire page with all Excel Files for All Videos: https://excelisfun.net/files/ 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.
IKEA Hacks: Organize Today
AI-recommended products based on this video
Loading...
Clear Acrylic Cats Hair Collector with Cats Pendant Decoration Keychain Furs Container for Travel Friendly Shape Pet Memorial Box
(0)
$7.43$3.50
FREE delivery Sep 11 - 16
Loading...
ESR for iPhone 16 Case, Military-Grade Protection, Shockproof Air Guard Corners, Yellowing-Resistant Acrylic Back, Phone Case for iPhone 16, Air Armor Series, New Clear Blue
(657)
$12.99
FREE delivery Sat, Jun 14 on your first order
Loading...
![Command Medium Picture Hanging Strips [Removable]: 12 Pairs (White)](https://m.media-amazon.com/images/I/61IChX1hbML._AC_UL960_FMwebp_QL65_.jpg)
Command Medium Picture Hanging Strips [Removable]: 12 Pairs (White)
(23,669)
$10.38
FREE delivery Mon, Sep 15 on your first order
5K+ bought in past month