-1983

767

INDEX() and MATCH() with two criteria.

-63

183

IF Funtion

-13

290

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

-3

257

-1

343

Count months between two dates

215

How to sum bottom n values in Excel.

156

search function

142

Using SUMPRODUCT to sum against various criteria

113

Using COUNTIF() to count values greater than a criteria

55

An Example of Sumifs criteria

0

712

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

490

Understanding INDIRECT() formula in MS Excel

309

Calculate the number of months between two dates

254

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

228

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

227

Getting only non-blank cell when checking for a crtieria

224

Rank on Filtered List

204

Using SUMPRODUCT() function to sum ranges.

202

Find the two characters representing US City in a string

198

Calculate how many days between two dates

1

152

How to sum values with multiple OR criteria.

82

Calculate Friday's between two dates

116

165

How to use NETWORDAYS() in excel

122

Using NETWORKDAYS formula

106

Using NETWORKDAYS() in MS Excel

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

124

How to use SUMPRODUCT function to validate a criteria and sum

137

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

169

Using HLOOKUP() function to retrieve values in tables.

INDEX() and MATCH() with two criteria.