-3967
1018
INDEX() and MATCH() with two criteria.
-127
373
IF Funtion
-53
444
How to use LOOKUP() function to look for values.
-3
350
-1
413
Count months between two dates
300
How to sum bottom n values in Excel.
267
Calculate how many days between two dates
218
search function
198
Using SUMPRODUCT to sum against various criteria
172
Using COUNTIF() to count values greater than a criteria
113
An Example of Sumifs criteria
0
815
Use MS Excel's CELL() formula to find the address of a cell
562
Understanding INDIRECT() formula in MS Excel
442
Calculate the number of months between two dates
320
Rank on Filtered List
315
Using SUMPRODUCT() function to sum ranges.
314
Using INDIRECT() function to read cell addresses and return corresponding values.
302
How to use MS Excel's ADDRESS() function to set cell addresses
281
Getting only non-blank cell when checking for a crtieria
252
Find the two characters representing US City in a string
1
216
How to sum values with multiple OR criteria.
137
Calculate Friday's between two dates
166
221
How to use NETWORDAYS() in excel
188
Using NETWORKDAYS formula
151
Using NETWORKDAYS() in MS Excel
141
How to use NETWORKDAYS.INTL() in MS Excel 2010.
173
How to use SUMPRODUCT function to validate a criteria and sum
156
185
How to use SUMPRODUCT() to sum against a criteria.
227
Using HLOOKUP() function to retrieve values in tables.
INDEX() and MATCH() with two criteria.