google sheet sum if value from other column code example Example: google sheets add all numbers in a column with condition =SUMIF(A5:A13,B1,B5:B13)