View Full Version : Excel Help!
Money Fist
02-24-2004, 08:09 PM
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!
I would like to know also
Excel is a genius program
just need to remember the math\equations
taxe declarations are coming up
tesco
02-25-2004, 12:40 AM
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.
The formula is =COUNTIF(range,number ur looking for)
eg. if ure lookin for 5 the formula is =COUNTIF(A1:A7,5)
Smurfette
02-25-2004, 10:45 AM
Originally posted by Zedaxax@25 February 2004 - 00:34
Excel is a genius program
...until you run out of 'if' statements in a cell. :/
Powered by vBulletin® Version 4.2.3 Copyright © 2024 vBulletin Solutions, Inc. All rights reserved.