IF Statement Values

[Sally Templin]

Column C has a drop box list. Column D has an If statement that links to Column C. i.e., Column C = Cash / Column D displays 50.

Why won't numbers in Column D that are linked to Column C sum in cell J3? Numbers manually input will work.

Thank you.

 

[Khalid NGO]

Hello Sally Templin, and welcome to the forum

Numbers in your formula are stored as TEXT VALUES due to "number":
=IF(C3="Cash","50",IF(C3="Cash Family","50",IF(C3="Cash HS 20","20",IF(C3="Cash FF","0",IF(C3="Cash HS 25","25",IF(C3="Cash M","30",IF(C3="Cash MR M","30",IF(C3="Cash PP","0",IF(C3="Cash Student","30",IF(C3="CHUSA","40",IF(C3="FREE","0")))))))))))

Will not be summed, try instead:
=IF(C3="Cash",50,IF(C3="Cash Family",50,IF(C3="Cash HS 20",20,IF(C3="Cash FF",0,IF(C3="Cash HS 25",25,IF(C3="Cash M",30,IF(C3="Cash MR M",30,IF(C3="Cash PP",0,IF(C3="Cash Student",30,IF(C3="CHUSA",40,IF(C3="FREE",0)))))))))))

Or since you have already maintained a lookup table, I suggest use the simple vlookup or index/match formula, for example use any of the following in D3:

=IFERROR(VLOOKUP(C3,$O$3:$P$14,2,FALSE),"")

=IFERROR(INDEX($P$3:$P$14,MATCH(C3,$O$3:$O$14,0)),"")
Copy down...

Regards,