excel magic trick 1482: sumproduct, dcounta or sum & if for counting with or logical test
Published 6 years ago • 6.5K plays • Length 20:12Download video MP4
Download video MP3
Similar videos
-
5:55
excel magic trick 1015: counting with or criteria: sumproduct & countif formula from pmsocho
-
12:28
excel magic trick 1197: or criteria: don’t double count: dcounta, countifs, or sumproduct?
-
27:03
excel magic trick 1467: countifs or sumproduct for complex counting formula? (3 examples)
-
9:25
excel magic trick 320: lookup adding: sumproduct & sumif
-
14:02
excel magic trick 1145: create random data set with formulas: 4 unusual formulas
-
7:11
excel magic trick 1311: return multiple items from one lookup value & show total for invoice items
-
3:06
excel magic trick 1171: sumifs & sumif treat 0500 & 00500 the same! use sumproduct instead
-
8:26
excel magic trick 982: add w one condition, use sumif instead of sumproduct or dsum
-
7:14
excel magic trick 1236: count numbers that contain whole number 4: countifs or sumproduct?