Just enter that value in the cell then.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"SRINIVAS.G_HYD" wrote in message
...
When I am using SUMIF function I want the name mentioned in " CRITERIA" to
be
displayed along with the result (the name should be displayed in
preceeding
cell of result)