google sheet add 1 to numbers in a column code example Example: google sheets add all numbers in a column with condition =SUMIF(A5:A13,B1,B5:B13)