Tag Archives: Big Number

SUMIF Formulas

1 Introduction At some point in your Excel work you are almost certainly going to want to conditionally sum a range of cells. If you find yourself in that situation then SUMIF() is probably going to be what you need: … Continue reading

Posted in Microsoft Excel | Tagged , , , , , , , , , , , , , , , , , , , | 12 Comments

Binary Searches With VLOOKUP

I went for a job interview about a year ago and the interviewer made a passing comment that he didn’t understand why anyone would ever pass TRUE into VLOOKUP’s  range_lookup parameter. There are lots of cases when you might want to … Continue reading

Posted in Microsoft Excel | Tagged , , , , , , , , , , , | 10 Comments