Cellwise · SQL track

Summaries with COUNT, SUM and AVG

Turn many rows into one number.

These work like their Excel namesakes: COUNT, SUM, AVG, MIN and MAX each turn many rows into one number.

Add WHERE to summarize only some of the rows, just like SUMIF or COUNTIF.

What you’ll do

• Count rows
• Total with a condition
• Several summaries at once