New Bug Encountered: cross-sheet sumifs formula shifts the result before doing a sum

Akram
New Member

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)

0 10 911
10 REPLIES 10
Top Labels in this Space