COUNTIF Cell Value is Negative

Hello!

I don't yet see this question put out there, so here we go:

I have a column that has both negative and positive values. I would like to create a formula that counts how many negative values exist in that column. (This is for a sheet summary).

Currently my formula looks like this:

=COUNTIF([Delta: Projected Hours vs. Worked & Forecasted], <0)

*My column name is Delta: Projected Hours vs. Worked & Forecasted.

Help?

Find more posts tagged with

Formulas

Countif

Accepted answers

All comments

KPH

This is a duplicate post. There is an answer on this thread https://community.smartsheet.com/discussion/114379/countif-cell-value-is-negative#latest

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.