cells evaluation question
 

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

cells evaluation question
 

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

Regards,
Fred


"Simon" wrote in message
...
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