Is there a way to combine a sumif and a countif function within one formula?

Michelle Tivis

I am trying to find the number of "tasks" completed within a certain date range.

The following are the formulas I have been using, but I can't figure out how to combine them.

=SUMIF({Content Type}, CONTAINS("Wiki", @cell), {Task Counter})

=COUNTIF({Date Received}, >=DATE(2022, 1, 1))

Find more posts tagged with

Accepted answers

All comments

Jeff Reisman

@Michelle Tivis

Can you provide a little more info on your use case here?

It seems like you want to just use SUMIFS, which allows you to specify more than one criteria range. The syntax is:

SUMIFS(range to sum, criterion range 1, criterion 1, criterion range 2, criterion 2...)

So in your case:

=SUMIFS({Task Counter}, {Content Type}, CONTAINS("Wiki", @cell), {Date Received}, >=DATE(2022, 1, 1))

English: Add the values from task counter column from rows where content type contains wiki and the date received is on or after January 1, 2022.

SUMIFS Function | Smartsheet Learning Center

Michelle Tivis

What I want to accomplish is to filter out the Content Type with the word wiki that was received on or after January 1, 2022 and count up the task counter for those rows.

I tried using the formula you suggested as the description is what I am trying to accomplish, but it still isn't working.

Jeff Reisman

https://community.smartsheet.com/discussion/comment/321097#Comment_321097

Are you getting an error message? That error message can tell you what might be wrong.

Formula Error Messages | Smartsheet Learning Center

I suspect it's either a range issue or a data issue. Make sure your Date Received column is really a date-type column containing real date values. You should see the little calendar icon when you click in one of the cells. Make sure your range sizes match (either the entire column or the exact same sub-set of rows.)

The formula itself works:

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.