A
A
ashasmod2015-06-17 21:38:19
Google
ashasmod, 2015-06-17 21:38:19

How to count the number of rows with the same value in Google Spreadsheets?

Good afternoon.
Please help, I can't figure it out.
How to count the number of rows with the same value in Google Spreadsheets (Google Sheets)?
For example: the table has a column "Destination", and each cell in it has one of the values, for example "Moscow", "Minsk", "Kyiv".
You need either a function that will itself look for the same values ​​in this column and display their number. Or I will specify which values, and the function will calculate the number for me.
If it's possible to enter a function on one sheet and the results on another, that's even better.
Thanks in advance.

Answer the question

In order to leave comments, you need to log in

2 answer(s)
A
AbHabr, 2015-06-17
@ashasmod

Have you read the help?
This: https://support.google.com/docs/answer/3093480 isn't it?

A
Alexander Bormintsev, 2015-06-17
@samcram

Pivot tables can do the job.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question