I have 2 sheets in a workbook on google drive Sheet 1, Sheet 2 In Sheet 1: there is a sumifs formula that adds value from Sheet2 based on a simple condition (example- In Sheet1 : Cell A10 has “Bob” Cell B10 has formula to sum all cells corresponding ...