Sumsif formula help

Hello-

I'm trying to build a sheet where i can open appointments chronologically after 75% of the appointments fill up. I currently have 4 appointments every 15 minutes. the only way i can think to do this is to add a sumsif formula and once 3/4 of the slots fill, to open the next set of appointments. if there's a better way to do this i'd love to know. in the meantime, my "sumsif" formula doesn't seem to be working;

=SUMIFS(Date@row :Date@row , Date@row :Date@row , "11/20/25", Time@row :Time@row , "9:15 AM")

Find more posts tagged with

Accepted answers

All comments

DKazatsky2

Hi @kbegin,

You should revamp this using COUNTIFS instead of SUMIFS. If the count is >0, take whatever action you need. Additionally, assuming the "Date" column is a DATE type, when you set the criteria, try using "DATE(2025, 11, 20)" instead of "11/20/25".

Hope this helps,

Dave

kbegin

Thanks, Dave. I did try that but it was only counting it for that row but i'm trying to get a total for the column if that makes sense. I will try that Date suggestion though. wondering if that's the issue! thank you!

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.