Excel Forum
Similar Content
Best Lookup Formula in Excel - Index and Match
Tutorial: A lookup using INDEX and MATCH is like a VLOOKUP without the restrictions.  Index and Mat...
Count Blank Cells in Excel
Tutorial: How to count blank cells, including formulas that output a blank. Sections: Count Blank C...
Return the Min or Max Value Using a Lookup in Excel - INDEX MATCH
Tutorial: Find the Min or Max value in a range and, based on that, return a value from another rang...

Excel Magic Trick 532: Count Blanks In Dynamic Range INDEX MATCH COUNTBLANK functions

See how to count blanks in a dynamic range using COUNTIF, INDEX, MATCH, COUNTA and OFFSET. Learn about the difference between an empty cell and a blank. See how to create dynamic ranges with INDEX and OFFSET (Index:Index). Learn about MATCH function using a 2 as the lookup value. Amazing use of INDEX to trick COUNTIF into not seeing an array! Domenic at Mr Excel Message Board xl-central.com xl-central xl-central[dot]com

Got a Question? Ask it Here in the Forum.