Count if cell is not blank

I am trying to figure out a formula to add if cells are not blank.

So for example, if the employer states he worked 1/21, 1/,22 and 1/23 the formula would state 3. Each date worked is in its own cell.

I tried the following

=COUNTIF([1st Travel Day Start Date]@row , [2nd Travel Day End Date]@row , "is Not Blank")

I received an invalid argument set error.

Thank you

Find more posts tagged with

Accepted answers

All comments

Anjanesh Vaidya

Hi @Amber K.
You can use the formula below:

=COUNTIF([1st Travel Day Start Date]@row:[2nd Travel Day End Date]@row, <>"")

Amber K.

I am looking for it to equal 3. The employee worked 1/21, 1/22 and 1/23.

Anjanesh Vaidya

@Amber K. Please share a snapshot for reference. I’d like to see how the entries are made and which columns are used. As mentioned in your formula, there are only two columns, and the entries don’t appear to be in a date format. Are these multi-select dropdown values like 1/21, 1/22, and 1/23?

Amber K.

@Anjanesh Vaidya

It is filled in with a date. The column format is date.

If 1st and 2nd Travel Day Start Date is filled in. I am trying to get the Total Travel Days to state 2.

Anjanesh Vaidya

@Amber K.

I can see in snapshot that there is a hidden column between 1st Travel Date Start Date and 2nd Travel Date Start Date. Please unhide that column and move it elsewhere, as it may be causing the issue. The formula is likely including this hidden column in the range, which can lead to errors or unexpected results because that column is also being calculated.

In your previous message, you expected the value to be 3, but now you want Total Travel Days to return 2. The suggested formula will return 2 only if the range includes two columns because each date column will only have one date.

I hope it helps!

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.