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.
Event’s event !
In a new “Total” column in Team Event stats, I will filter Events for them to match :
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
Let me know if it’s not that clear so I can send photos.
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!
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.
