SUMIFS Formula Referencing Cells Containing Dates

INDEX MATCH With a Twist

January 12, 2012

INDEX MATCH With a Twist

My Toughest Excel Challenge So Far! Recently a member contacted me with a VLOOKUP question, but when I further understood

Read More
Excel INDIRECT Function

December 14, 2011

Excel INDIRECT Function

The Excel INDIRECT Function has many applications and perhaps its simplest is to fix a range of cells you want

Read More
Excel TIME Function

September 28, 2011

Excel TIME Function

The Excel TIME function combines separate hour, minute and second values and converts them into a time serial number. If

Read More
Excel Array Formula

June 15, 2011

Excel Array Formula

Knowing Excel array formulas will catapult you to ‘Guru Status’ in your office and I'll do my best to make

Read More