Summing values in a range w/ criteria

SOLVED !!!!!!! Thanks guys.


I have columns of hundreds of data points that I would like to add data between a fixed numerical value. The numerical values always start at zero, then increase to a non fixed maximum value, then reduce back to zero. The number of data points (column Data A) is usually a fixed value that starts at 1 and increases to a fixed value.


Example: I would like to sum values in the Data B column that are greater than 0.040 only (0.1482+0.2257+0.3167+0.325+0.3152+0.2231+0.1534)

Data A ---- Data B
1 ---------- 0.0055
2 ---------- 0.0385
3 ---------- 0.1482
4 ---------- 0.2257
5 ---------- 0.3167
6 ---------- 0.3250
7 ---------- 0.3152
8 ---------- 0.2231
9 ---------- 0.1534
10 --------- 0.0397
11--------- 0.0053

I tired using "SUMIF", but I'm must not be using it correctly.
Any assistance will be appreciated.

You don't need the B1:B11 sum range repeated. Use just

=SUMIF(B1:B11,">0.04")