SQL Query With SUM()

Hi,
I have one single table with the follwing fields:
ID, Status,Group, Owner,Code
The code field contains (high,Low,Medium) Data
I would like to retrieve the sum of the code field for a specific owner
and group.

Owner Code(total of highs, lows and Mediums)
------- ----------------
name 7
Here is my sql
SELECT ID, OWNER,GROUP,CODE, STATUS FROM tablename
GROUP BY
OWNER, CODE HAVING sum( Status) <> 'Closed' AND OWNER='name'
AND Group='grpname'
I'm new to ORacle and I hope this make sens.
Thanks in advance.

Does the Code field actually contain the text "High", "Medium" and "Low"???

Post some sample data.

Yes it does

okay, dumb question then...how do you plan on summing the values of text? answer: You can't.
Where's your sample data.

I think I got it. I just needed to use Count(*) instead of Sum()
here is the query
Select COUNT(*) From Tablename
WHERE STATUS <> 'Closed' AND OWNER='name'.

Thank you anyway