excel magic trick 674: or criteria counting 3 examples countif, sumproduct & sum-countif

Published 14 years ago • 4.3K plays • Length 6:09

Download video MP4
Download video MP3

Similar videos

5:55

excel magic trick 1015: counting with or criteria: sumproduct & countif formula from pmsocho
27:03

excel magic trick 1467: countifs or sumproduct for complex counting formula? (3 examples)
12:28

excel magic trick 1197: or criteria: don’t double count: dcounta, countifs, or sumproduct?
4:46

excel magic trick 545: count between dates with 3 criteria countifs & dcounta & sumproduct
5:00

excel magic trick 728: countif & and functions check whether 3 specific people worked together
2:17

excel magic trick #396: countif function and multiplying
5:23

excel - countifs with multiple criteria and or logic
6:12

how to add new row automatically in an excel table
6:48

how to use the excel sequence function
3:46

excel magic trick 1095: count doubles & triples using frequency function (better than countif)
5:38

excel magic trick 1047: "number 225", & "text 225.00" same for countif, sumifs, dsum, dcount??
8:21

excel magic trick 572: countif & sumifs functions & logical formulas have different syntax
11:36

excel magic trick 683: 3 and criteria & 3rd and has or criteria -- add, count & conditional format
6:57

excel magic trick 1181: formula to count cells with 4 or more characters: countifs & sumproduct
3:06

excel magic trick 1171: sumifs & sumif treat 0500 & 00500 the same! use sumproduct instead
7:14

excel magic trick 1236: count numbers that contain whole number 4: countifs or sumproduct?
20:12

excel magic trick 1482: sumproduct, dcounta or sum & if for counting with or logical test
8:05

sum, count & average using an or logical test. many cool formulas. excel magic trick 1647
5:46

excel magic trick 1246: counting with case sensitive criteria: exact & sumproduct
5:16

excel magic trick 1248: add or count case sensitive contains criteria: isnumber, find, sumproduct

Clip.africa.com - Privacy-policy