excel magic trick 1036: sum rectangular table, 1 condition row headers & or criteria column headers
Published 11 years ago • 11K plays • Length 6:02Download video MP4
Download video MP3
Similar videos
-
12:09
excel magic trick 1426: lookup row & column headers from 2-way lookup table with unique values
-
2:52
index function to lookup column inside countifs function - excel magic trick 1574
-
2:18
excel magic trick 643: if function to pull data from a different column
-
9:16
excel sumifs : how to sum columns based on criteria and column header
-
6:05
excel magic trick 922: lookup row, then lookup value in row & return column header: two way lookup
-
20:47
magic search bar v3.0: reloaded with multiple worksheet and specific column search
-
3:28
excel magic trick 1054: change absolute cell reference each time column has new text entry
-
10:29
excel 2010 magic trick 798: partial text lookup formula to return multiple e-mail records
-
2:52
excel magic trick 1142: get every other row with formula: index and rows*2
-
7:38
excel magic trick 696: identify first occurrence in column (5 methods)
-
4:58
excel magic trick 1253: can i make vlookup use column headers? yes: use vlookup & match!
-
12:42
excel magic trick 1010: sumproduct to multiply filtered columns or columns with hidden rows
-
3:56
excel magic trick 1237: add with "contains criteria" or partial text criteria: sumifs & wildcard
-
7:10
excel magic trick 886: two way lookup, list names in tabular table (row & column criteria)
-
7:23
excel magic trick 781: three way lookup: index and match and concatenated ranges & cells
-
9:33
excel magic trick 478: reverse two way lookup for date and time column and row headers
-
3:23
excel magic trick 339: sum differences with 2 criteria sumproduct
-
5:26
excel magic trick 1513: countifs from multiple cells!?!? array formula or logical formula?
-
10:20
tocol, drop, expand array functions to unpivot data into proper table. excel magic trick 1785
-
3:23
sum based on row & column criteria in excel
-
10:26
excel magic trick 1024: sumif & sumifs function & mixed cell references & dynamic table range
-
8:53
excel magic trick 297: add certain column only