In excel, how can I search for a cell containing a certain text, then select the cell below to add to a formul?

Sounds like you need to use a SUMIF or COUNTIF formula, but I'm not completely sure what you're trying to do.