SUMIFS Formula Referencing Cells Containing Dates
Formulas containing dates and time in Excel can be frustrating if you don’t understand how they work. And even if you do they seem to work differently from one formula to another! A few weeks ago Dave wrote to me as he was having trouble getting a SUMIFS formula to correctly use dates referenced in …