-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.