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.

SYNTAX (aka how to write it):

=VLOOKUP(SearchValue, SearchRange, ColumnNumberOfReturnValue, TypeOfMatch)

• SearchValue - this is the value you want to find within the first column of the SearchRange.

• SearchRange- this is the full range of cells that include the SearchValue and the returned value.

• ColumnNumberOfReturnValue- this is the number of the column within the SearchRangethat holds the value you want to return if the value in the first column matches the SearchValue .

• TypeOfMatch- this is either "true" for an approximate match or "false" for an exact match. Most of the time we will use "false" for this entry.