How to calculate certain items for a given fiscal year.

cthrasher97141

I am trying to count (COUNTIFS) during a given fiscal year. My fiscal year runs from the month of July - June, so currently I am in fiscal year 2024-2025.

Column Fiscal Year = Dropdown

Column Activity = Text

Column Activity Type = Text

Column Total = Text with calculation

If I change the Fiscal Year the Total column should recalculate based on its value.

Thank you for the help!

heyjay

What column do you want to Count?

cthrasher97141

I apologize, I count is coming from another sheet.

It will based on the Created date and Quantity.