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 to Bob in Sheet2).
=sumifs(Sheet2!B:B,Sheet2!A:A,Sheet1!A10)
Sheet2:
Row Number 1 Name Expense
Row Number 2 Bob 1000
Row Number 3 Kirstin 20100
Row Number 4 Bob 2000
Row Number 5 Asuncion 15000
Row Number 6 Paulina 3000
Row Number 7 Paulina 3000
Row Number 8 Many 1000
Row Number 9 Otilia 1000
Row Number 10 Paulina 2000
Row Number 11 Delta 1000
Google sheet is correctly adding row number 2 & 4 (1000+2000 = 3000)
But, Appsheet is showing addition of row number 3 & 5 (20100+15000 = 35100)
Also, If I just clear the cell B3 in Sheet2, Appsheet is showing addition of row number 4 & 6 (2000+3000 = 5000)
User | Count |
---|---|
44 | |
35 | |
25 | |
24 | |
15 |