Count value from Row
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.
Best Answer
-
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
Answers
-
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
Help Article Resources
Categories
Check out the Formula Handbook template!