cells evaluation question

  • Thread starter Thread starter Simon
  • Start date Start date
S

Simon

Hey

I have a spreadsheet with 9 cells (c14:c22)
They will have integers entered from 0 to 10

I need a formula to do the following:

- Find how many have a value >=5
- Get the total value of the cells with a value >=5


Thanks

Simon
 
You want Countif and Sumif, as in:
=countif(c14:c22,">=5")
=sumif(c14:c22,">=5")

Regards,
Fred
 
Back
Top