How to perform sum of data between different tables?

[Rica-2c2d]

Hello everyone!
I'm building a project for an Inventory Management app, but I'm not able to apply the SUMIF function, to add the total consumption of a table in relation to the item description.
If anyone has a trip I will be very grateful!

[Razi]

You can use SUM around a FILTER expression on a column.

Here is an example of this:

Updating field based on a calculation

You can use the power of automatic formula recalculation within the table to sum the total credits. The formula will automatically get recalculated whenever data in the transaction table changes - including when rows are added, when they are deleted, and when the value in the Credits column changes. There is no need for you to write any automation, or do any other special handling. The best way to do this is to specify a Column formula. You can do this by selecting the Total Credits column (…

Thanks,
Razi

[Rica-2c2d]

Dear Razi,
Thanks a lot for the help.
It worked!

:sorrindo:

[Amir-9ee1]

Can you provide a sample

[Alyssa]

Hi @Amir-9ee1, welcome to the community!

There are examples in this link in Razi's reply, does that help?

Otherwise, could you let us know what formula you need assistance with?

[Amir-9ee1]

yes it does

[Amir-9ee1]

HI @Alyssa,
I have a question.
My tables turn into Sheet, and I am not able to create a new table under the current project. do you have any Idea why it happened ? and how Can I fix it ?

[Pankaj]

Hi @Amir-9ee1 ,

I think we covered this question in another community post.

I just want to make sure that this is being handled.