google sheets add up whole column if one cell is equal to code example Example: google sheets add all numbers in a column with condition =SUMIF(A5:A13,B1,B5:B13)