Hi all,
i have a sheet on excel with 5 rows that, for each rows, sum some value from sheet 1 using some condition. Values are prices
Below an example of the formula i’m using on excel:
=SUMIFS(Expense!D:D;Expense!C:C;“A”;Expense!F:F;“Yes”)
=SUMIFS(Expense!D:D;Expense!C:C;“B”;Expense!F:F;“Yes”)
=SUMIFS(Expense!D:D;Expense!C:C;“C”;Expense!F:F;“Yes”)
=SUMIFS(Expense!D:D;Expense!C:C;“D”;Expense!F:F;“Yes”)
=SUMIFS(Expense!D:D;Expense!C:C;“E”;Expense!F:F;“Yes”)
the last row is the sum of the previous.
On AppSheet the value is not correctly shown. I have the text #VALUE! when i try to show the cell value on a table.
How can i fix this solution?
Thanks in advance!
LinkedIn
Twitter
