I was wondering if there was a formula for counting text in excel I know the basic formula however what I want it to count is as follows. 1-tandem 2-tandem 3-tandem but be able to pick up the numbers in front of the word as well and condense it all into one count. Is this possible? I can set it up to count the word tandem by itself but I am doing a scheduling spreadsheet and have more than one tandem on certain jobs so being able to count up all the trucks under certain names would be beneficial.