How to calculate certain items for a given fiscal year.

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!

Find more posts tagged with

Formulas

Accepted answers

All comments

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.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.