Adding Data Validation List.

[1dancier]

I cannot add the information as shown below. The Data Validation list generates names and from those names I generate numbers through a nested IF statement but I cannot add those numbers generated.

Column A = Plain number with no formula.
Column B = Data validation list.
Column C = Nested IF statement to generate score for grade from 1-4
Column D = Copy of column C but without IF statements attached (=c3)
Column E = formula (=sum(D3:D10)
Column E Total = 0



<TABLE style="BACKGROUND-COLOR: #ffffff; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; FONT-FAMILY: Calibri,Arial; FONT-SIZE: 11pt" border=1 cellSpacing=0 cellPadding=0><COLGROUP><COL style="WIDTH: 63px"><COL style="WIDTH: 100px"><COL style="WIDTH: 90px"><COL style="WIDTH: 64px"><COL style="WIDTH: 102px"></COLGROUP><TBODY><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; FONT-WEIGHT: bold">A</TD><TD style="TEXT-ALIGN: center; FONT-WEIGHT: bold">B</TD><TD style="TEXT-ALIGN: center; FONT-WEIGHT: bold">C</TD><TD style="TEXT-ALIGN: center; FONT-SIZE: 10pt; FONT-WEIGHT: bold">D</TD><TD style="TEXT-ALIGN: center; FONT-WEIGHT: bold">E</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; FONT-SIZE: 12pt; FONT-WEIGHT: bold">Number</TD><TD style="TEXT-ALIGN: left; FONT-SIZE: 12pt; FONT-WEIGHT: bold">Grade</TD><TD style="TEXT-ALIGN: center; FONT-SIZE: 12pt; FONT-WEIGHT: bold">Score</TD><TD style="TEXT-ALIGN: center; FONT-SIZE: 12pt; FONT-WEIGHT: bold">Score</TD><TD style="TEXT-ALIGN: center; FONT-SIZE: 12pt; FONT-WEIGHT: bold">Total</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: left">1</TD><TD style="TEXT-ALIGN: left; FONT-SIZE: 12pt">Satisfactory</TD><TD style="TEXT-ALIGN: center">1</TD><TD style="TEXT-ALIGN: center; FONT-SIZE: 10pt">1</TD><TD style="TEXT-ALIGN: right">0</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: left">2</TD><TD style="TEXT-ALIGN: left">Very Good</TD><TD style="TEXT-ALIGN: center">3</TD><TD style="TEXT-ALIGN: center; FONT-SIZE: 10pt">3</TD><TD></TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: left">3</TD><TD style="TEXT-ALIGN: left">Very Good</TD><TD style="TEXT-ALIGN: center">3</TD><TD style="TEXT-ALIGN: center; FONT-SIZE: 10pt">3</TD><TD></TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: left">4</TD><TD style="TEXT-ALIGN: left">Excellent</TD><TD style="TEXT-ALIGN: center">4</TD><TD style="TEXT-ALIGN: center; FONT-SIZE: 10pt">4</TD><TD></TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: left">5</TD><TD style="TEXT-ALIGN: left">Good</TD><TD style="TEXT-ALIGN: center">2</TD><TD style="TEXT-ALIGN: center; FONT-SIZE: 10pt">2</TD><TD></TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: left">6</TD><TD style="TEXT-ALIGN: left">Not Started</TD><TD style="TEXT-ALIGN: center">0</TD><TD style="TEXT-ALIGN: center; FONT-SIZE: 10pt">0</TD><TD></TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: left">7</TD><TD style="TEXT-ALIGN: left">Not Started</TD><TD style="TEXT-ALIGN: center">0</TD><TD style="TEXT-ALIGN: center; FONT-SIZE: 10pt">0</TD><TD></TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: left">8</TD><TD style="TEXT-ALIGN: left">Excellent</TD><TD style="TEXT-ALIGN: center">4</TD><TD style="TEXT-ALIGN: center; FONT-SIZE: 10pt">4</TD><TD></TD></TR></TBODY></TABLE>

 

[Ingolf]

Hi,
Check column D (D3:D8) to be formated as "number" or "general".
Couse for me work that sum=17

 

[Haldoug]

You may want to investigate the use of the lookup and the vlookup function instead of nested if to assign the values in column C. That would eliminate copying the value into column D.

 

[markmzz]

Try this formula in D3 =VALUE(C3)

Look at this:

Excel 2007<TABLE style="BORDER-BOTTOM: #a6aab6 1px solid; BORDER-LEFT: #a6aab6 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-COLLAPSE: collapse; BORDER-TOP: #a6aab6 1px solid; BORDER-RIGHT: #a6aab6 1px solid" rules=all cellPadding=2><COLGROUP><COL style="BACKGROUND-COLOR: #e0e0f0" width=25><COL><COL><COL><COL><COL><COL><COL><COL></COLGROUP><THEAD><TR style="TEXT-ALIGN: center; BACKGROUND-COLOR: #e0e0f0; COLOR: #161120"><TH></TH><TH>A</TH><TH>B</TH><TH>C</TH><TH>D</TH><TH>E</TH><TH>F</TH><TH>G</TH><TH>H</TH></TR></THEAD><TBODY><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">1</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">2</TD><TD style="FONT-WEIGHT: bold">Number</TD><TD style="FONT-WEIGHT: bold">Grade</TD><TD style="TEXT-ALIGN: center; FONT-WEIGHT: bold">Score</TD><TD style="TEXT-ALIGN: center; FONT-WEIGHT: bold">Score</TD><TD style="TEXT-ALIGN: center; FONT-WEIGHT: bold">Total</TD><TD style="TEXT-ALIGN: right"></TD><TD style="FONT-WEIGHT: bold">Grade</TD><TD style="TEXT-ALIGN: center; FONT-WEIGHT: bold">Score</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">3</TD><TD style="TEXT-ALIGN: right">1</TD><TD>Satisfactory</TD><TD style="TEXT-ALIGN: center">1</TD><TD style="TEXT-ALIGN: center">1</TD><TD style="TEXT-ALIGN: center">17</TD><TD style="TEXT-ALIGN: right"></TD><TD>Not Started</TD><TD style="TEXT-ALIGN: center">0</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">4</TD><TD style="TEXT-ALIGN: right">2</TD><TD>Very Good</TD><TD style="TEXT-ALIGN: center">3</TD><TD style="TEXT-ALIGN: center">3</TD><TD style="TEXT-ALIGN: center"></TD><TD style="TEXT-ALIGN: right"></TD><TD>Satisfactory</TD><TD style="TEXT-ALIGN: center">1</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">5</TD><TD style="TEXT-ALIGN: right">3</TD><TD>Very Good</TD><TD style="TEXT-ALIGN: center">3</TD><TD style="TEXT-ALIGN: center">3</TD><TD style="TEXT-ALIGN: center"></TD><TD style="TEXT-ALIGN: right"></TD><TD>Good</TD><TD style="TEXT-ALIGN: center">2</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">6</TD><TD style="TEXT-ALIGN: right">4</TD><TD>Excellent</TD><TD style="TEXT-ALIGN: center">4</TD><TD style="TEXT-ALIGN: center">4</TD><TD style="TEXT-ALIGN: center"></TD><TD style="TEXT-ALIGN: right"></TD><TD>Very Good</TD><TD style="TEXT-ALIGN: center">3</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">7</TD><TD style="TEXT-ALIGN: right">5</TD><TD>Good</TD><TD style="TEXT-ALIGN: center">2</TD><TD style="TEXT-ALIGN: center">2</TD><TD style="TEXT-ALIGN: center"></TD><TD style="TEXT-ALIGN: right"></TD><TD>Excellent</TD><TD style="TEXT-ALIGN: center">4</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">8</TD><TD style="TEXT-ALIGN: right">6</TD><TD>Not Started</TD><TD style="TEXT-ALIGN: center">0</TD><TD style="TEXT-ALIGN: center">0</TD><TD style="TEXT-ALIGN: center"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">9</TD><TD style="TEXT-ALIGN: right">7</TD><TD>Not Started</TD><TD style="TEXT-ALIGN: center">0</TD><TD style="TEXT-ALIGN: center">0</TD><TD style="TEXT-ALIGN: center"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">10</TD><TD style="TEXT-ALIGN: right">8</TD><TD>Excellent</TD><TD style="TEXT-ALIGN: center">4</TD><TD style="TEXT-ALIGN: center">4</TD><TD style="TEXT-ALIGN: center"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD></TR></TBODY></TABLE>Sheet1


<TABLE style="BORDER-BOTTOM: black 2px solid; BORDER-LEFT: black 2px solid; PADDING-BOTTOM: 0.4em; BACKGROUND-COLOR: #ffffff; PADDING-LEFT: 0.4em; PADDING-RIGHT: 0.4em; BORDER-COLLAPSE: collapse; BORDER-TOP: black 2px solid; BORDER-RIGHT: black 2px solid; PADDING-TOP: 0.4em" rules=all cellPadding=2 width="85%"><TBODY><TR><TD style="PADDING-BOTTOM: 6px; PADDING-LEFT: 6px; PADDING-RIGHT: 6px; PADDING-TOP: 6px">Worksheet Formulas<TABLE style="BORDER-BOTTOM: #a6aab6 1px solid; TEXT-ALIGN: center; BORDER-LEFT: #a6aab6 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-COLLAPSE: collapse; BORDER-TOP: #a6aab6 1px solid; BORDER-RIGHT: #a6aab6 1px solid" rules=all cellPadding=2 width="100%"><THEAD><TR style="BACKGROUND-COLOR: #e0e0f0; COLOR: #161120"><TH width=10>Cell</TH><TH style="TEXT-ALIGN: left; PADDING-LEFT: 5px">Formula</TH></TR></THEAD><TBODY><TR><TH style="BACKGROUND-COLOR: #e0e0f0; COLOR: #161120" width=10>C3</TH><TD style="TEXT-ALIGN: left">=VLOOKUP(B3,$G$3:$H$7,2,0)</TD></TR><TR><TH style="BACKGROUND-COLOR: #e0e0f0; COLOR: #161120" width=10>D3</TH><TD style="TEXT-ALIGN: left">=VALUE(C3)</TD></TR><TR><TH style="BACKGROUND-COLOR: #e0e0f0; COLOR: #161120" width=10>E3</TH><TD style="TEXT-ALIGN: left">=SUM(D3:D10)</TD></TR><TR><TH style="BACKGROUND-COLOR: #e0e0f0; COLOR: #161120" width=10>C4</TH><TD style="TEXT-ALIGN: left">=VLOOKUP(B4,$G$3:$H$7,2,0)</TD></TR><TR><TH style="BACKGROUND-COLOR: #e0e0f0; COLOR: #161120" width=10>D4</TH><TD style="TEXT-ALIGN: left">=VALUE(C4)</TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE>


Markmzz

 

[1dancier]

Thanks for the response guys, I never thought about using Vlookup, next time. I solved my problem by using the formula in column D =sum(C2+0) , this allowed me to add column D.



<TABLE style="BACKGROUND-COLOR: #ffffff; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; FONT-FAMILY: Calibri,Arial; FONT-SIZE: 11pt" border=1 cellSpacing=0 cellPadding=0><COLGROUP><COL style="WIDTH: 124px"><COL style="WIDTH: 100px"><COL style="WIDTH: 90px"><COL style="WIDTH: 75px"></COLGROUP><TBODY><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; FONT-SIZE: 12pt; FONT-WEIGHT: bold">File Number</TD><TD style="TEXT-ALIGN: center; FONT-SIZE: 12pt; FONT-WEIGHT: bold">Grade</TD><TD style="TEXT-ALIGN: center; FONT-SIZE: 12pt; FONT-WEIGHT: bold">Score</TD><TD style="TEXT-ALIGN: center; FONT-SIZE: 12pt; FONT-WEIGHT: bold">Score</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: left">1</TD><TD style="TEXT-ALIGN: left">satisfactory</TD><TD style="TEXT-ALIGN: center">1</TD><TD style="TEXT-ALIGN: center; FONT-SIZE: 10pt">1</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: left">XXX</TD><TD style="TEXT-ALIGN: left">very good</TD><TD style="TEXT-ALIGN: center">3</TD><TD style="TEXT-ALIGN: center; FONT-SIZE: 10pt">3</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: left">3</TD><TD style="TEXT-ALIGN: left">very good</TD><TD style="TEXT-ALIGN: center">3</TD><TD style="TEXT-ALIGN: center; FONT-SIZE: 10pt">3</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: left">4</TD><TD style="TEXT-ALIGN: left">excellent</TD><TD style="TEXT-ALIGN: center">4</TD><TD style="TEXT-ALIGN: center; FONT-SIZE: 10pt">4</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: left">5</TD><TD style="TEXT-ALIGN: left">good</TD><TD style="TEXT-ALIGN: center">2</TD><TD style="TEXT-ALIGN: center; FONT-SIZE: 10pt">2</TD></TR></TBODY></TABLE>

 

[markmzz]

1dancier,

Sorry, I was thinking that you need the Score too. So another way to sum the column C (array formula - use Ctrl+Shift+Enter and not only Enter):


<b>Excel 2007</b><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color: #A6AAB6"><colgroup><col width="25px" style="background-color: #E0E0F0" /><col /><col /><col /><col /></colgroup><thead><tr style=" background-color: #E0E0F0;text-align: center;color: #161120"><th></th><th>A</th><th>B</th><th>C</th><th>D</th></tr></thead><tbody><tr ><td style="color: #161120;text-align: center;">1</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">2</td><td style="font-weight: bold;;">Number</td><td style="font-weight: bold;;">Grade</td><td style="font-weight: bold;text-align: center;;">Score</td><td style="font-weight: bold;text-align: center;;">Total</td></tr><tr ><td style="color: #161120;text-align: center;">3</td><td style="text-align: right;;">1</td><td style=";">Satisfactory</td><td style="text-align: center;;">1</td><td style="text-align: center;;">17</td></tr><tr ><td style="color: #161120;text-align: center;">4</td><td style="text-align: right;;">2</td><td style=";">Very Good</td><td style="text-align: center;;">3</td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">5</td><td style="text-align: right;;">3</td><td style=";">Very Good</td><td style="text-align: center;;">3</td><td style="text-align: center;;"></td></tr><tr ><td style="color: #161120;text-align: center;">6</td><td style="text-align: right;;">4</td><td style=";">Excellent</td><td style="text-align: center;;">4</td><td style="text-align: center;;"></td></tr><tr ><td style="color: #161120;text-align: center;">7</td><td style="text-align: right;;">5</td><td style=";">Good</td><td style="text-align: center;;">2</td><td style="text-align: center;;"></td></tr><tr ><td style="color: #161120;text-align: center;">8</td><td style="text-align: right;;">6</td><td style=";">Not Started</td><td style="text-align: center;;">0</td><td style="text-align: center;;"></td></tr><tr ><td style="color: #161120;text-align: center;">9</td><td style="text-align: right;;">7</td><td style=";">Not Started</td><td style="text-align: center;;">0</td><td style="text-align: center;;"></td></tr><tr ><td style="color: #161120;text-align: center;">10</td><td style="text-align: right;;">8</td><td style=";">Excellent</td><td style="text-align: center;;">4</td><td style="text-align: center;;"></td></tr><tr ><td style="color: #161120;text-align: center;">11</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">12</td><td style="text-align: center;;">******</td><td style="text-align: center;;">******</td><td style="text-align: center;;">******</td><td style="text-align: center;;">******</td></tr></tbody></table><p style="width:3.6em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid #A6AAB6;border-top:none;text-align: center;background-color: #E0E0F0;color: #161120">Sheet2</p><br /><br /><table width="85%" cellpadding="2.5px" rules="all" style=";border: 2px solid black;border-collapse:collapse;padding: 0.4em;background-color: #FFFFFF" ><tr><td style="padding:6px" ><b>Array Formulas</b><table cellpadding="2.5px" width="100%" rules="all" style="border: 1px solid;text-align:center;background-color: #FFFFFF;border-collapse: collapse; border-color: #A6AAB6"><thead><tr style=" background-color: #E0E0F0;color: #161120"><th width="10px">Cell</th><th style="text-align:left;padding-left:5px;">Formula</th></tr></thead><tbody><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">D3</th><td style="text-align:left">{=SUM(<font color="Blue">1*(<font color="Red">C3:C10</font>)</font>)}</td></tr></tbody></table><b>Entered with Ctrl+Shift+Enter.</b> If entered correctly, Excel will surround with curly braces {}.
<b>Note: Do not try and enter the {} manually yourself</b></td></tr></table><br />
Markmzz

 

[markmzz]

Another (without array formula):

=SUMPRODUCT(1*(C3:C10))

Markmzz

 

[T. Valko]

I cannot add the information as shown below. The Data Validation list generates names and from those names I generate numbers through a nested IF statement but I cannot add those numbers generated.

Column A = Plain number with no formula.
Column B = Data validation list.
Column C = Nested IF statement to generate score for grade from 1-4
Column D = Copy of column C but without IF statements attached (=c3)
Column E = formula (=sum(D3:D10)
Column E Total = 0



<TABLE style="PADDING-RIGHT: 2pt; PADDING-LEFT: 2pt; FONT-SIZE: 11pt; FONT-FAMILY: Calibri,Arial; BACKGROUND-COLOR: #ffffff" cellSpacing=0 cellPadding=0 border=1><COLGROUP><COL style="WIDTH: 63px"><COL style="WIDTH: 100px"><COL style="WIDTH: 90px"><COL style="WIDTH: 64px"><COL style="WIDTH: 102px"></COLGROUP><TBODY><TR style="HEIGHT: 18px"><TD style="FONT-WEIGHT: bold; TEXT-ALIGN: center">A</TD><TD style="FONT-WEIGHT: bold; TEXT-ALIGN: center">B</TD><TD style="FONT-WEIGHT: bold; TEXT-ALIGN: center">C</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; TEXT-ALIGN: center">D</TD><TD style="FONT-WEIGHT: bold; TEXT-ALIGN: center">E</TD></TR><TR style="HEIGHT: 19px"><TD style="FONT-WEIGHT: bold; FONT-SIZE: 12pt; TEXT-ALIGN: center">Number</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 12pt; TEXT-ALIGN: left">Grade</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 12pt; TEXT-ALIGN: center">Score</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 12pt; TEXT-ALIGN: center">Score</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 12pt; TEXT-ALIGN: center">Total</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: left">1</TD><TD style="FONT-SIZE: 12pt; TEXT-ALIGN: left">Satisfactory</TD><TD style="TEXT-ALIGN: center">1</TD><TD style="FONT-SIZE: 10pt; TEXT-ALIGN: center">1</TD><TD style="TEXT-ALIGN: right">0</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: left">2</TD><TD style="TEXT-ALIGN: left">Very Good</TD><TD style="TEXT-ALIGN: center">3</TD><TD style="FONT-SIZE: 10pt; TEXT-ALIGN: center">3</TD><TD></TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: left">3</TD><TD style="TEXT-ALIGN: left">Very Good</TD><TD style="TEXT-ALIGN: center">3</TD><TD style="FONT-SIZE: 10pt; TEXT-ALIGN: center">3</TD><TD></TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: left">4</TD><TD style="TEXT-ALIGN: left">Excellent</TD><TD style="TEXT-ALIGN: center">4</TD><TD style="FONT-SIZE: 10pt; TEXT-ALIGN: center">4</TD><TD></TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: left">5</TD><TD style="TEXT-ALIGN: left">Good</TD><TD style="TEXT-ALIGN: center">2</TD><TD style="FONT-SIZE: 10pt; TEXT-ALIGN: center">2</TD><TD></TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: left">6</TD><TD style="TEXT-ALIGN: left">Not Started</TD><TD style="TEXT-ALIGN: center">0</TD><TD style="FONT-SIZE: 10pt; TEXT-ALIGN: center">0</TD><TD></TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: left">7</TD><TD style="TEXT-ALIGN: left">Not Started</TD><TD style="TEXT-ALIGN: center">0</TD><TD style="FONT-SIZE: 10pt; TEXT-ALIGN: center">0</TD><TD></TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: left">8</TD><TD style="TEXT-ALIGN: left">Excellent</TD><TD style="TEXT-ALIGN: center">4</TD><TD style="FONT-SIZE: 10pt; TEXT-ALIGN: center">4</TD><TD></TD></TR></TBODY></TABLE>

What does your IF formula look like?

If it has numbers that are quoted remove the quotes. Sort of like this:

Don't do this:

=IF(A1="X","1","")

Do it like this:

=IF(A1="X",1,"")

When you quote numbers that turns them into TEXT strings. The SUM function ignores TEXT strings.