# Need help with a Formula based on a cell we made contains Month and Year

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 :

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

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.