howeverthere is mistake in one of the , rows in this sheet that' too many rows to check by hand luckilyyou can write script that checks the totals as hintyou can access the individual cells in row with ss[ getrow (rownum)where ss is the spreadsheet object and rownum is the row number remember that row numbers in google sheets begin at not the cell values will be stringsso you'll need to convert them to integers so your program can work with them the expression int(ss[ getrow( )[ ]int(ss[ getrow( )[ ]=int(ss[ getrow( )[ ]evaluates to true if the row has the correct total put this code in loop to identify which row in the sheet has the incorrect total