FORMULA QUESTION/HELP

I am trying to create a formula that counts anything under 8 days in a column but by month and Fiscal year as well. Below is what I created and I get an unparseable error. Any suggestions?

=COUNTIFS({Depot Repair Collection Log Range 8}, <8, {Collection Repair Log Range 6}, "4", {Depot Repair Collection Log Range 4}, "FY2024))

Find more posts tagged with

Accepted answers

All comments

jmyzk_cloudsmart_jp

@Heather Druckenmiller

If {Depot Repair Collection Log Range 8} is a text range, {Depot Repair Collection Log Range 8},VALUE(@cell)<8

If {Collection Repair Log Range 6}, is a number range, {Collection Repair Log Range 6}, 4

Scott Peters

Hi @Heather Druckenmiller - I notice you don't have " quote symbol on both sides of FY2024. Also, COUNTIFS is expecting all of your conditions to be true at the same time, is that your intent?

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.