Formula to count values in a column

BESP10 · 02/07/19

Good evening

VERY NEW to smartsheet.

I am creating a metrics sheet for data we want to capture on another sheet.

How do I get the QTY of "beam" counts in this column?

Thank you

Andrée Starå · 02/08/19

Hi,

I'd recommend counting and collect the metrics needed on the sheet first and then use cell linking to the metric sheet if needed.

Try this.

=COUNTIF([Piece Type]:[Piece Type]; "Beam")

The same version but with the below changes for your and others convenience.

=COUNTIF([Piece Type]:[Piece Type], "Beam")

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

Let me know if you still want/need to collect it directly on the metric sheet, and if you need information on how to set up cross-sheet linking.

Would that work?

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

BESP10 · 02/09/19

That worked

So simple...

Never to old to learn

Thank you !

Andrée Starå · 02/09/19

Great!

Happy to help!

Best,

Andrée

BESP10 · 02/26/19

Good evening,

Sorry to bother, but I thought I got this to work but I am getting an "unparseable" error.....

I have the formula as =COUNTIF([Piece Type]23:[Piece Type]352),"Other") but it is not counting

What could I be doing wrong here?

Thanks

Andrée Starå · 02/27/19

Hi,

No worries! I'm always happy to help!

You have one parenthesis too much. The one after 352 shouldn't be there.

=COUNTIF([Piece Type]23:[Piece Type]352),"Other")

Did it work?

Best,

Andrée

BESP10 · 02/27/19

YES!!!!!

Thank you!

Andrée Starå · 02/27/19

Great!

I'm always happy to help!

Best,

Andrée

BESP10 · 02/27/19

Is it possible to use the "children" function here? so that as more rows get added to the bottom we do not need to update formula everytime?

Thank you

Andrée Starå · 02/27/19

Yes, try this.

=COUNTIF(CHILDREN([Piece Type]22), "Other")

Did it work?

Best,

Andrée

BESP10 · 02/27/19

Hmmm, this formula gives me the proper count of 5 -

=COUNTIF([Fab Type]27:[Fab Type]372, "Bolt/Weld")

But when I change it to

=COUNTIF(CHILDREN([Fab Type]27), "Bolt/Weld")

It comes up as 0 ?

Andrée Starå · 02/27/19

It's probably because you're referencing a child row and not the parent row.

If it's the same row as on your picture, then try changing it to row 22.

Did it work?

Best,

Andrée

BESP10 · 02/27/19

BINGO!

Thanks

Andrée Starå · 02/27/19

to help!

Best,

Andrée

Formula to count values in a column

Comments

Categories