Sum of certain cells from another sheet


Hi I am new to Airtable, I am moving our sales record to Airtable. I am trying to get the sum of some cells from another sheet and having a hard time. This is super simple in excel or numbers. I was wondering if anyone can help? I looked everywhere but couldn’t find anything.

in the first sheet we record all of our data on a daily basis, I want to be able to sum up parts of each column (eg. to get the monthly total sale). Am I missing something?


Excel is very different, I recommend you to read this: