{"type":"video","version":"1.0","html":"<iframe src=\"https://www.loom.com/embed/1b2ee681dd2344eb8f594c916241ebcb\" frameborder=\"0\" width=\"1728\" height=\"1296\" webkitallowfullscreen mozallowfullscreen allowfullscreen></iframe>","height":1296,"width":1728,"provider_name":"Loom","provider_url":"https://www.loom.com","thumbnail_height":1296,"thumbnail_width":1728,"thumbnail_url":"https://cdn.loom.com/sessions/thumbnails/1b2ee681dd2344eb8f594c916241ebcb-00001.gif","duration":83.83333333333331,"title":"How to Calculate Total Fees Paid in Google Sheets 👩‍💻","description":" Hey there! In this video, I'll show you how to easily calculate the total number of fees paid in a report pulled from Civic Review using Google Sheets. First, we'll locate the column we need to calculate in, which is column G for term fees paid. Then, we'll find a suitable spot to write the total. I'll guide you through using the \"sum\" formula to add up all the numbers in the column. If the formula suggestion pops up, you can simply click on it, but if not, don't worry, I'll show you how to type it out. Once we've highlighted all the numbers, we'll close the parentheses and hit return or enter. Voila! You'll have the total amount of fees paid. It's a quick and handy trick that will save you time and effort. Enjoy the video and let me know if you have any questions or need further assistance. Happy calculating! 📊"}