COUNTIFS isn't working

I am trying to count all the number of 0s within a column. I am using this formula

=COUNTIFS([Warranty Remaining]:[Warranty Remaining], 0)

but it does not work. What is weird is that, I changed the formula from [Warranty Remaining] to count a specific number in the [Warranty Obligations] column and it worked fine. I've even changed the name of the column the formula is in and I only get 0 instead of the accurate 0s in the column. The column has many 0,1,2,3,4,5,6 and I just want to count the 0s.

Thanks in advance

Find more posts tagged with

Accepted answers

All comments

Jason Albrecht

Potentially a silly question, but are the zero's really zero's and not 0.000123 as an example?

Would the formula work if it was looking for numbers less than 1 ?

LeAndre P

Yes the 0s are 0s however, the following formula is in the column providing the data for the COUNTIFS column.

=IF([Warranty Expiration Date]@row > TODAY(), NETDAYS(TODAY(), [Warranty Expiration Date]@row) / 365, IF([Warranty Expiration Date]@row < TODAY(), "0"))

I don't believe this is an issue because both formulas are playing well with each other in two other columns.

Jason Albrecht

So, I'm wondering if the inverted commas around the 0 is converting the number to a text?

What happens if

your count ifs formula looks for "0" instead of 0 ? or
your Warranty Expiration Date inserts a 0 instead of "0" ?

LeAndre P

Hi Jason,

I've tried the formula both ways, both with and without the commas to no avail.

LeAndre P

I got it working. It turns out is was the commas in the formula supplying the data causing the problem.

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.