Count value from Row

Namrata Tewar

Hello Team,

I need your help to count value form row. Here is my question.

So I want to count all C0 in my whole spool numbers.

I tried formula =COUNTIF([Spool Number]1:[Spool Number]926 @row, CONTAINS("C0",@cell))

Please correct me where I am wrong.

Thank you.

Find more posts tagged with

Community Platform

Accepted answers

Genevieve P.

Hi @Namrata Tewar

To reference an entire column, you'll want to list the column name twice without numbers.

Instead of:

[Spool Number]1:[Spool Number]926

Use:

[Spool Number]:[Spool Number]

Try this:

=COUNTIF([Spool Number]:[Spool Number], CONTAINS("C0", @cell))

Cheers,

Genevieve

All comments

Genevieve P.

Hi @Namrata Tewar

To reference an entire column, you'll want to list the column name twice without numbers.

Instead of:

[Spool Number]1:[Spool Number]926

Use:

[Spool Number]:[Spool Number]

Try this:

=COUNTIF([Spool Number]:[Spool Number], CONTAINS("C0", @cell))

Cheers,

Genevieve

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.