COUNTIF will do what you asked -- count the number of occurrences of
"prepaid".

On Mon, 6 Jun 2005 18:45:21 -0700, JerryS
wrote:

I have a column that contains two sets of information displayed as

173.05 prepaid
49.95
174.03 prepaid
149.95
149.95

I'd like a sumproduct search that counts only the number of times a cell
containg "prepaid" is listed. There are other criteria and columns which is
why I prefer to use sumproduct but am open to anything. Thanks

JerryS