Excel Tips & Tricks - XelPlus

more criteria to be checked. The traditional SUMIF and COUNTIF functions allowed only 1 condition whereas the new functions allow up to 127 criteria. For example you can sum the values in Column C if the values in Column A and Column B meet a certain criteria – you can set up to 127 criteria. ................
................