Excel Help!

[Money Fist]

i have a range of numbers
eg
4
5
6
5.5
5
2
4

whats is the formulea to tell me how many
5s are in my data range?

my little cuz needs help
and i seem to have forgot how todo this one!

[100%]

I would like to know also

Excel is a genius program
just need to remember the math\equations

taxe declarations are coming up

[tesco]

wel i guess u better go to insert>functions and start searching for the one u want, im warning you now that there are a lot of functions to go through. i looked at a few of the common ones but it will take to long to do every single one so u can try.

[SP1]

The formula is =COUNTIF(range,number ur looking for)

eg. if ure lookin for 5 the formula is =COUNTIF(A1:A7,5)

[Smurfette]

Originally posted by Zedaxax@25 February 2004 - 00:34
Excel is a genius program
...until you run out of 'if' statements in a cell. :/