cells evaluation question

[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

 

[Fred Smith]

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

Regards,
Fred