Why isn't my countif updating?

My countif is adding the number of "4"s in a range of rows starting at row 33 and moving to the end of the data (presently at row 41).

I'm adding new rows using a form but the row number 41 isn't increasing. So the new values aren't being counted.

=COUNTIF([Strategy...value]33:[Strategy...value]41, 4)

How do I get this to work?

Find more posts tagged with

Accepted answers

All comments

Paul Newcome

The only way to get it to work is to reference the entire column.

DJT

But my formula is in the column so I can't reference the whole column i.e. 7 is where my formula is

Number of 4's	7

4 - Expert/Excellent knowledge	4
4 - Expert/Excellent knowledge	4
4 - Expert/Excellent knowledge	4
3 - Working knowledge	3
4 - Expert/Excellent knowledge	4
4 - Expert/Excellent knowledge	4
4 - Expert/Excellent knowledge	4
3 - Working knowledge	3
3 - Working knowledge	3
3 - Working knowledge	3
4 - Expert/Excellent knowledge	4

Also if I copy the added row (from the form) into the middle of the data then the countif updates and includes the figures so it's working just not at the bottom.

Paul Newcome

IF that is the only cell in that column that will reference that column, Smartsheet will actually allow a single instance of a circular reference as long as it meets some strict conditions.

Are you also counting the other numbers at the to of that same column? Are you able to move these summary counts to other columns or another sheet? What is the purpose of these summary counts?

DJT

i moved the countif to a different sheet and did the countif on the whole column and now it works. Thanks

Paul Newcome

Happy to help. 👍️

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.