Sumif function using the "conditional sum wizard"

[Bob L.]

I need to sum one column of numbers if an array of number
is between two other numbers. So I use the following
formula: =SUM(IF($A$5:$A$20>=C1,IF
($A$5:$A$20<=C2,$C$5:$C$20,0),0))
The data is as follows with #VALUE! being in cell C3. The
result should be 2.5, which is what shows when I click in
the fx key to see where I went wrong. So the function
seems to be correctly calculating what I want but it just
won't print it. Any ideas?
4
10
#VALUE!
Num Code Points
1 L 0.75
2 T 0.25
3 P 0.50
4 A 1.00
5 -
6 -
7 L 0.75
8 P 0.50
9 T 0.25
10 -
11 -
12 -
13 -
14 -
15 -
16 -
-
-
Legend:
A 1.00
L 0.75
P 0.50
T 0.25

 

[Aladin Akyurek]

You need to confirm the formula with control+shift+enter instead of just
with enter.

Alternatively, you could use a SumProduct formula for multiconditional
summing.