Non-contiguous means not next to each other. Use ALT as shortcut key to apply sum. Text strings in criteria must be enclosed in double quotes ie.
Steps to Open the SUM Function in Excel You can simply enter the desired SUM formula in the required cell to attain a return value on the argument.
SUMIF function will perform SUM. SUMIF only supports one condition. Steps to Open the SUM Function in Excel You can simply enter the desired SUM formula in the required cell to attain a return value on the argument. Use AutoSum or press ALT to quickly sum a column or row of numbers.