What's the difference? COUNT vs COUNTA vs COUNTALL

[@alexdimonaco8602]

Duuuudee that multiselect counter formula saved me hours. Thanks Julian.

[@imarithkongtho]

Thanks for this useful video

[@julian_post]

Glad it was helpful!

[@LuisRdzG10]

Hi Julian, What if I want to count for a specific name?, using your example, what if I want to know how many points Harry Potter has for Gryffindor row and put that value in a column? But I want to be dynamic, I mean, not only Harry Potter, How many Ronald, etc. I Know it's tricky, but I'm so confused. Using an SQL syntaxis I would imagine is something like : Count (ValueField) Where (NameField) is == "[Name you want]" . But Airtable has no "where" in Formulas, some other languages uses a "For Each", so it could be a "For each (NameField) Count (ValueField)" Thanks, if you read this

[@BernardAguila-l4k]

Hi Julian, I wanted to know how to create a field that counts the quantity of links for a Client for the month.

[@julian_post]

One easy way to do this would be to add a formula field to the records which you're linking to, and make the formula output the number 1 for every record. Then in your summary table, rollup that formula field and limit the rollup to only records within that month. Then sum the values and you'll get 1 for every linked record in that month

[@BernardAguila-l4k]

@@julian_post Thank you! I will try it. Coz I'm having a hard time using roll ups

[@jfbmusic]

Hi Julian, thanks for a great video, learned a lot, especially around Look Up and Rollup fields use of COUNT, etc. Just so you know, your recommended videos' overlays don't appear at the end (kzbin.info/www/bejne/kIrJaJt8htaorcU). Keep up the great work!

[@julian_post]

Fixed! Thank you!!