COUNTIFS formula error

Smartsheet_amh1999

I am trying to calculate training sessions based on 2 columns : status column and year column. I've done this numerous times before however for some reason no matter what status filter I choose the outcome is 0 when there are definitely values for 2024 completed training sessions.

This is the formula I am using =

=COUNTIFS({Training Tracker Range 2}, "Completed", {Training Tracker Range 3}, "2024")

Any help would be greatly appreciated!!

Find more posts tagged with

Sheets

Dashboards

Sheet Summary

Accepted answers

All comments

KPH

The formula syntax looks fine. Here are some things to check.

Does range 3 contain the value 2024 or is it a date?
Are both ranges the same size, in other words are there rows that are in one range but not the other?

Can you try with just one of the criteria and then the other to see which could be causing the problem.

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.