How can I total no. particular parameter of certain column?

I want to collect data from a table. There are various parameters which I should count number of a parameter at one column with a limitation. parameter is no. of motorcycles with speed limit of 80km in the column of speed.

[Stephen23]

Original question by Hamed Abshari on 3rd September 2015, retrieved from Google Cache:

"How can I total no. particular parameter of certain column?"

I want to collect data from a table. There are various parameters which I should count number of a parameter at one column with a limitation. parameter is no. of motorcycles with speed limit of 80km in the column of speed.

[Rena Berman]

(Answers Dev) Restored edit

Answer 1

[Purushottama Rao]

if the column wit speed data is denoted as s then use

sum(s>80)
which gives the desired value