2 articles 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”) You can replace 0 with the value you need. The condition inside the formula can…


Zero if error or #N/A in Vlookup

zero if error #N/A

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 returned by the VLOOKUP function when there is no match to the searched element. The…