COUNTIF to count cells with a date less than, and ignore blank cells

Good afternoon.

I am trying to count some data in a Date Closed column.

I want to count the number of cells showing a date less than 4/30/21. There are some blank cells that I am not sure how to account for.

=COUNTIF({Circle K Summary Date Closed}, @cell <= DATE(2021, 4, 30))

I am also going to want to sum the amounts in a Final Sale Price column as related to these dates. For instance, sum all sales prices in the smartsheet column for closing less than 4/30/21.

Appreciate the help. I keep playing with it. Might come to me in the middle of the night and I am reading a ton of posts, but just can't get it right.

Thanks.

Find more posts tagged with

Accepted answers

All comments

Sameer Karkhanis

COUNTIF will not include blank cells so you should be good with the blank cells.

For the sum use the same expression with SUMIF function like,

=SUMIF({Circle K Summary Date Closed}, <= DATE(2021, 4, 30), [Final Sale Price]:[Final Sale Price])

french2s

The Countif is working. I had a mistake in my summary sheet.

If I want it between dates - such as between 5/1/22 and 4/30/23, what does that formula look like?

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.