SUMIF with two expressions

Hi Guys!

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.

4 Likes

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.