Excel 2007 Sum Column of Cells Over Specific Amount

Hello,

Can anyone assist in putting a formula together that will sum a column of cells but only cells that are 3.50 or higher on a 1 - 5 point scale?  For example, the attached file shows a range of scores in column A.  This is dummy data but live data will have a variety of scores ranging from 1.00 - 5.00.  I need a sum formula that will look at the column and only sum the cells with a score of 3.5 or higher.

Thanks!
EE-Sample.xlsx
LVL 1
EscanabaAsked:
Who is Participating?
 
AmickCommented:
=SUMIF(A1:A216,">=3.5")
0
 
jppintoCommented:
Using SUMPRODUCT() function:

=SUMPRODUCT((A1:A216>=3,5)*(A1:A216))

jppinto
0
 
jppintoCommented:
Using SUMIF() function:

=SUMIF(A1:A216;">=3,5";A1:A216)

jppinto
SUMIF.xlsx
0
 
EscanabaAuthor Commented:
Thanks!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.