Sorry in advance if this has been asked multiple times before but after googling I could not find it.
What I want to do:
I want to SUM table2.price in a column in table 1 IF table2.categorie = thisrow.categorie AND table2.type = “aspecificterm”
I tried it with lookups and filters and sumif but I cant get it to work.
Try something like this out! If its not working, you can share an example/dummy doc and we can help you get it up and running.
table2.filter(category = thisRow.category and type="aspecificterm").price.sum()
Essentially you are using the filter formula to pull matching rows from table2, drawing out the price information, then adding it together.
My savior!! This worked like a charm. I am not sure why I thought I had to use double ( ) and stuff like that. This seems so easy.
I’m wondering why my result shows like this
It generates the result but there are some errors because it’s not number.
It looks to me like your “value” column which you are trying to sum is actually a “text” type.
If you change the column type of your value column to a number would it get rid of those errors for you?
I think it’s a bug! This time, I copied the values from normal excel cells rather than excel table and Coda recognizes it properly.