Excel Magic Trick 1197

OR Criteria: Don’t Double Count: DCOUNTA, COUNTIFS, or SUMPRODUCT?


See how take two columns of county numbers and kip codes and show unique list of county codes vertically, and then for each county code, list zips codes horizontally.
(00:09) OR Criteria Double Count Problem when criteria are coming from Two Columns
(01:33) DCOUNT function formula
(03:35) COUNTIFS function formula (3 COUNTIFS in one formula)
(06:35) SUMPRODUCT function formula (Array Formula)
(10:28) Timing all 2 formulas


Be the first to comment

Leave a Reply