I am trying to calculate our “Event Total” and the date is on another sheet:

Trying to see how we could calculate these months total using a row in our “Past Orders” sheet that has a “Total” cell.

If I did not explain it well, please feel free to ask me questions.

Thank you!

Hi @Renee_O

Not sure I understood 100% but I’ll try, assuming that you want to summarize data from an `Event`

table to `Team Event Stats`

table

I created those 2 tables, using a true real Date Column in `Team Event Stats`

, and using `MonthName()`

formula if you prefer to display plain text.

I assigned random dates to

`Event`

’s event !

In a new “Total” column in Team Event stats, I will filter Events for them to match :

current month
current year
that will give me a list of event

Finally, just `Count()`

the number of events like this

Is that want you wanted to achieve ?

Cheers

Quentin

Thank you, we are on the right track! What we wanted to achieve is

the total $$$ of the event instead of count. How should we do this?
and should be based on a row of a cell which we put (Jan 2022, Feb 2022) in another sheet so we wanted to use the data from the other sheet to calculate the total $$$ based on the month (Jan 2022, Feb 2022)
Let me know if it’s not that clear so I can send photos.

Considering you’ve got an `Amount`

column in your event table :

Renee_O:

and should be based on a row of a cell which we put (Jan 2022, Feb 2022) in another sheet so we wanted to use the data from the other sheet to calculate the total $$$ based on the month (Jan 2022, Feb 2022)

Sorry, I did not understand this one

No worries, here you go!

We have this stats table:

If we want to put the total $$$ we got from Jan 2022, we’ll need the details from this different sheet:

How do we make that a formula for all the succeeding months?

OK, that’s what I explained in my previous post

My table EVENTS is like your table PAST ORDERS
and my column AMOUNT si like your column TOTAL

So if I rename my tables, here you go :

Thank you! Can we change the formula by basing it on the month format “January 2022” because the rows has “January 2022” etc as well.

Hi @Renee_O
this is exactly the same principle, just filter with `Contains()`

function, but honestly I would not recommand it, as this is not as scalable as using `Month()`

and `Year()`

function.

i’ll let you adapt the filter formula then !

Ohh awesome! I have figured it out. Your help is much appreciated!

1 Like

system
Closed
November 12, 2023, 10:44am
10
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.