I’m using the new Google tables in Google sheets. The name of my table is DB. One of my columns is Type and several columns are names of different properties. One of the options for the Type field is Income. I want to create a named function that sums up all rows with type Income for a given property.
My Named Function settings are as follows:
- Function Name:
INCOME - Argument Placeholder:
property - Formula
Definition:= sumif(DB[Type],"Income",DB[property])
This formula definition is saying “formula parse error”.
What should the correct formula be?
EDITED:
Here is a working example: Google Sheets Example
The answer should be $35. The correct formula (without using named functions) is below the table.
Here is a snippet of the attempt to enter the named function:
2
Change:
= sumif(DB[Type],"Income",DB[property])
To:
=SUMIF(db_type, "Income", db_property)
The named function should look like this:
I’ve used
db_typeanddb_propertyas theArgument placeholdersbecause usingDB[Type]andDB[property]gives out the messageUnderscores are the only allowed special characters. This could be the reason why you’re getting theFormula parse error; check formula syntaxmessage on theFormula definitionearlier.
OUTPUT
2