Trying to calculate the SUM of multiple IF statement cells but not getting any value except "0"

[asmyth]

Hi,

I have created a multiple IF statement to display a certain value based on the text of a list box cell. The formula is working correctly and I have pasted it into 6 other cells.
The problem occurs when I try to calculate the SUM of the 7 cells. I have entered a simple SUM statement for the range of cells but I am not getting any value except "0". The column next to the IF statement cells is for free-form numbers and the SUM statement works fine for those numbers.
I have searched forums and found resolutions like SUMIF, SUMIFS, COUNTIF, and COUNTA statements but none of them have worked.
Is there a special SUM statement to calculate the range of cells with multiple IF statements?

The following statement is my multiple IF statement:
=IF(C3="EASY","5",IF(C3="MEDIUM","10",IF(C3="HARD","15",IF(C3="ADVANCED","Enter hours manually here >",IF(ISBLANK(C3),"0")))))

The following SUM statements are ones I have tried without success:
=SUM(D3:D9)
=SUMIF(D3:D9,">0")

I have also formatted the SUM cell as a Number while attempting my SUM formula.

I am using MS Excel 2003 on Windows XP SP3.

Thank you,
Adam

 

[Aladin Akyurek]

Remove the double quotes around the numbers...

 

[asmyth]

I feared it would be something simple and stupidity on my part
Thank you for the quick and concise reply.