Escanaba
asked on
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks!
=SUMPRODUCT((A1:A216>=3,5)
jppinto