hello collin,

you may try this it may fit your need,

=SUM(IF(NOT(ISERROR(FIND("<",A1:A100,1))),(RIGHT(A 1:A100,LEN(A1:A100)-FIND("<",A1:A100,1)))*{1}))*1/2
hit ctrl-shft-ent.
FOR DATA LIKE "<2007" or "KO<2007"
regards
--
*****
birds of the same feather flock together..



" wrote:

Does anyone know if I can do this...

I have a column of values that I would like to find the average of,
but
some of the cells contain numbers with a < in front of them.
The average should use 1/2 the value of the numbers with < in front of
them.

Thanks in advance for your help!

Colleen