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