-1983

886

INDEX() and MATCH() with two criteria.

-127

298

IF Funtion

-27

363

How to use LOOKUP() function to look for values.

-3

301

-1

374

Count months between two dates

257

How to sum bottom n values in Excel.

233

Calculate how many days between two dates

183

search function

167

Using SUMPRODUCT to sum against various criteria

145

Using COUNTIF() to count values greater than a criteria

86

An Example of Sumifs criteria

0

766

Use MS Excel's CELL() formula to find the address of a cell

533

Understanding INDIRECT() formula in MS Excel

362

Calculate the number of months between two dates

283

Using INDIRECT() function to read cell addresses and return corresponding values.

282

Rank on Filtered List

274

How to use MS Excel's ADDRESS() function to set cell addresses

256

Using SUMPRODUCT() function to sum ranges.

253

Getting only non-blank cell when checking for a crtieria

230

Find the two characters representing US City in a string

1

188

How to sum values with multiple OR criteria.

110

Calculate Friday's between two dates

142

191

How to use NETWORDAYS() in excel

151

Using NETWORKDAYS formula

133

Using NETWORKDAYS() in MS Excel

123

How to use NETWORKDAYS.INTL() in MS Excel 2010.

150

How to use SUMPRODUCT function to validate a criteria and sum

134

163

How to use SUMPRODUCT() to sum against a criteria.

196

Using HLOOKUP() function to retrieve values in tables.

INDEX() and MATCH() with two criteria.