• Adding_amounts_greater_than_zero
    Useful formulas

    Adding amounts greater than zero

    Adding amounts greater than zero or another given value in Excel is sometimes required and can be acquired by using the SUMIF or SUMIFS formulas. The formula for adding amounts greater than a given value =SUMIFS(sum range, sum range, “>0”)…

  • zero if error #N/A
    Useful formulas

    Zero if error or #N/A in Vlookup

    Sometimes the result of an excel formula is an element of a larger and sophisticated calculation which will end displaying an error if any of the elements taken into account is not a number. This is the case of #N/A…