Formulas: sum if and counter

[riccardoch]

Is there a method to determine the number of occurrences in a column/row or to calculate the sum only when a certain condition is met?

If not, for counting occurrences, I'd expect something like:

<!-- TBLFM: @>$2=count(@I..@-1, @=="Riccardo") -->

As for the 'sum if' function:

<!-- TBLFM: @>$2=sumif(@I..@-1, @>0) -->

For both functions the parameters could be:

• range of values
• condition evaluated for each individual value

[jreeves123]

Second this request! I didn't see this explained in the formula documentation under nested formulas (where I expected it)