First, select cells containing numbers. You can either select rows or columns ... to add numbers that are less than 9. So we will type =SUMIF(D2:D6,”<9″). Once done, press Enter, and this will be the ...