3 Intermediate Spreadsheet Functions for Equestrian Programs

COUNTIF()

Are you tracking quantities in any way? Perhaps you're keeping a log of pro rides completed in each week for each horse in your boarding barn. You can use this function to count the number of rides for each horse without using a "SUM" function or manually filtering/totaling the rides yourself. Let the spreadsheet do the work for you! *note this function will count anything in a cell such as text and number values.

SUMIF()

Looking for the sum of some actual numbers based on another criteria? Look no further! This function will add up the numerical values based on the same criteria as COUNTIF(). This is useful if you are tracking costs for certain horses or are trying to add up show fees for a client out of a log or makeshift ledger.

VLOOKUP()

Curious if your current clients are new or returning for the cycle? You can compare names, emails, phone numbers, and more using the VLOOKUP function! This function lets you compare 2 sets of data how you would like.